Calculate Start Date and End Date of Current Month

Below is the formula to Calculate Start Date and End Date of current month

Month Start Date

UpdateContext({
   monthStartDate: 
   Date(
     Year(Now()), Month(Now()), 1)
   )
})

Month End Date

UpdateContext({
   monthEndDate:
   DateAdd(
     DateAdd(
        Date(Year(Now()), Month(Now()),1),
        1, Months
     ),
     -1, Days
   )
})

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s