calcdate

john_cage · May 23, 2003, 7:57am

Hello, If I use CALCDATE(’<-1Y>’,WORKDATE), I get for instance 23/05/02. But how do I get the begining of the month → 01/05/02 as result? Thank You [:)]

Kbara · May 23, 2003, 8:05am

Hi, There’s a few threads about this on the forum if you do a search, but for now this should do the trick: CALCDATE(’-CM-1Y’,WORKDATE); -CM will return the first day of the current month, the -1Y will deduct a year from that. Hope that helps…

john_cage · May 23, 2003, 8:07am

Thanks, I just find it but i could’nt delete the topic [:I]

john_cage · May 23, 2003, 1:55pm

also don’t know how to make 01/02/2003 → FEBRUARY 2003 Do I have to “hard” code to do that or can I use a fonction? Format? How? Thank You

DAD · May 23, 2003, 2:12pm

You can use DATE2DMY(date,2) and “hard code” the result.

Kbara · May 23, 2003, 2:17pm

…or you can use FORMAT, for example: FORMAT(WORKDATE,0,’ ')