From: Rene Gayer on
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
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
> >
> >
> >