Date formulas
in [Navision]
|
From: Rene Gayer on 10 Dec 2007 16:00 ops, yes that's right .. sorry I have forgotten to change the language. :) "anfinnur, formula.fo" wrote: > I guess that T1, T2, T3, ... is the German version of D1, D2, D3, ... ;) > > "D10" means -"the next 10th day of a month, current or next, after today".
From: RedFoxUA on 12 Dec 2007 02:28
you write: ========== as example varDate = 12/05/07 and you will use CALCDATE(T10,varDate) you would get = 12/10/07 But if you use CALCDATE(T4,varDate) you would get = 01/04/08!!! .... NOW: CALCDATE(T6,varDate) you would get = 06/12/07 ========== May be last line: ... = 12/06/07 (before you write mm/dd/yy and dd/mm/yy) Thank you. "Rene Gayer" wrote: > Hi, > yes there is an important difference: > > as example varDate = 12/05/07 and you will use > > CALCDATE(T10,varDate) you would get = 12/10/07 > But if you use > CALCDATE(T4,varDate) you would get = 01/04/08!!! > > Other examples: (same varDate) > CALCDATE(T1,varDate) you would get = 01/01/08 > CALCDATE(T2,varDate) you would get = 02/01/08 > CALCDATE(T3,varDate) you would get = 03/01/08 > CALCDATE(T4,varDate) you would get = 04/01/08 > CALCDATE(T5,varDate) you would get = 05/01/08 > NOW: > CALCDATE(T6,varDate) you would get = 06/12/07 > > The reason is that the system returns the next date which equal the > calculation if the number of the day you are using is before or equal to the > number of the day which you are using as date. > > So it depends on the date you are using which result you will get.(same > month or later – you can also use "-T1" to get the date before the date > which equals the result) > > So if you want to be sure to return always the 10th of the month you should > use CM+10T > > Ok, difficult to describe ;-) - I hope you understand what I mean? > > Regards, > Rene > > "ryanb." wrote: > > > Are the date formulas CM+10D and D10 essentially the same thing? Why would > > you want to use one in place of the other? > > > > TIA, > > > > -- > > _________________________ > > ryanb. > > NA 4.00 SP1 (4.0 SP3) SQL > > Running via Citrix > > > > > > |