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
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!!!
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)
"Rene Gayer" wrote:
> 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
> 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?
> "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