Date Formula

taher.bha

Hi All,
This is my first post in mibuso, i'm struggling to understand date formula in Navision.

Am trying to find a date formula to find the last friday of the month which is different of the month's end.
I can retrieve the last friday of the month using this formula :

MESSAGE (FORMAT(CALCDATE('<CM-WD5>', TODAY) ));

Is there any way to make a conditional date formula ?

How to find the month's end for (today + 30 days)

Thx in advance,

Malajlo

Last day in next month:

MESSAGE (FORMAT(CALCDATE('<CM>', calcdate('1M',TODAY)) ));

taher.bha

Thx Malajlo. I was wondering if this could be done directly by the use of a formula. This may be useful to setup payment terms for example.
May be the only possible solution for the date am looking for (month's end for (today + 30 days) ) would be to make an approximation of it with the following formula : <CM+30D>
I think that it is not exactly the same.
Am i right ?

DenSter

Same thing, only:

MESSAGE (FORMAT(CALCDATE('<CM>', calcdate('30D',TODAY)) ));

I don't know if your example would work, you should try it.