Date formulas
in [Navision]
|
From: ryanb. on 4 Dec 2007 11:24 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
From: RedFoxUA on 4 Dec 2007 11:58 It is different. <CM+10D> = Currect Month + 10days <10D> = 10 days only "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 > > >
From: ryanb. on 4 Dec 2007 14:31 I think you misread my post: not 10D, but D10 (as in day 10 of the month) Is there a difference? Thanks "RedFoxUA" <RedFoxUA(a)discussions.microsoft.com> wrote in message news:80C24ED6-F0E0-4FCE-BC56-B5E4002B9522(a)microsoft.com... > It is different. > <CM+10D> = Currect Month + 10days > <10D> = 10 days only > "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 >> >> >>
From: Rene Gayer on 5 Dec 2007 15:50 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 > > >
From: anfinnur, formula.fo on 6 Dec 2007 06:50
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". |