Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

No of Week according to Month formula modify

Topic Labels: Formulas
368 1
Showing results for 
Search instead for 
Did you mean: 


I use this formula to define the week number according to the month and it resets again starting the new month.
LPSD is my Licence Period start date


it’s giving me a wrong week no: week -47. when it’s week 5
Screen Shot 2020-12-02 at 3.39.50 PM

is there a slight modify can solve this?

1 Reply 1

This appears to be a bug in the Datetime_Format function. Just running this formula on dates December 27-31, 2020 results in a “1” when it should be “53”