Date Formula

taher.bha
taher.bha Member Posts: 48
edited 2008-04-11 in NAV/Navision Classic Client
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,

Comments

  • Malajlo
    Malajlo Member Posts: 294
    Last day in next month: 
    MESSAGE (FORMAT(CALCDATE('<CM>', calcdate('1M',TODAY)) ));
  • taher.bha
    taher.bha Member Posts: 48
    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
    DenSter Member Posts: 8,307
    Same thing, only: 
    MESSAGE (FORMAT(CALCDATE('<CM>', calcdate('30D',TODAY)) ));
    I don't know if your example would work, you should try it.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories