Reseting date

Business Central/NAV Developers Forum
1

Hello there, got following problem, hope someone can help me : I have a date e.g. 27.01.02. Now I would like to “reset” this date to the first of the month. So, I have 27.01.02 → I get 01.01.02 How can this be done ? Thanx, Christian

2

Hi! CALCDATE('-LM', <Date>) Regards, Jörg

3

Great, thanks ! Christian

4

CALCDATE(’-CM’, dateVar); should do the trick - unless you are working with the German version like I do, then it’s CALCDATE(’-LM’, datumsVar); [;)] In English, the C stands for “current”, while the L stands for “laufend”. Additional tip: If you omit the -, you get the last day instead.