calendar quarter

[raadwiptec]

Hi all,

I need 4 quarter dates monthend dates to be generated on the script starting from 2021 based on the calendar year

For Ex>

20210331

20210630

20210930

20211231

[abhijitnalekar]

Hi @raadwiptec ,

Please check the below screenshot.  I hope you are looking for the same.

[raadwiptec]

yes but the date format should be YYYYMMDD

[abhijitnalekar · Accepted solution]

Hi @raadwiptec ,

Please modify the expression as below.

date(quarterend(invoicedate),'YYYYMMDD')