Report StartDate and EndDate Parameters


I’m going to ask about the start and end date parameters in the reports module.

I write this for report startdate parameter for the beginning of each month and it works.

dateFormat(dateArithmetic(now(0),0,‘days’) , “yyyy-MM-01 00:00:00”)

But how to specify the end date parameter for the last day of the every month

thank you.

I think this is what you need.

Thank you but trying this method

Last day of month:

addDays( getDate( getYear({date}), getMonth({date}) + 1, 1 ), -1 )

I’m typing the enddate parameters but getting an error.

Also, do I need to add anything?

Try changing {date} to now(0)

1 Like