Start date of month and End date of Month

Version 2

    hi,

         this is simple way how we can use Start date of month and End date of month in a calculated field.

    so, Start date of month :-

                                             DATETRUNC('month',[Order Date]) ;

           End date of month :-

                                           DATEADD('day',-1,  MAKEDATE(YEAR([Order Date]), MONTH([Order Date])+1,1))

     

      these are calculations u can use in a calculated field

     

    best regards ,

    Amrit