# date formula

hi all,

whats the diff btwn 2d & d2?

i ask f1 for help but he did not mention much help, but one think for sure, d=day!

also i realised if i put calcdate(d2, today) & calc(2d, today) what would be the respective output?
given today= 21/10/11

30D 30 days

D15 On the 15th of each month

for me it gave 2 diff results

Message(’%1’,CALCDATE(’<2D>’,TODAY)); = 23/10/11

Message(’%1’,CALCDATE(’’,TODAY)); =02/11/11

hi mohana_cse06,

appreciate your testing and explanation, but i don’t quite understand for situation 2 :d2, how is it able to output 2/11/11 instead of 2nd october 2011?

D2 is the upcoming 2nd date of next month…

If you use -D2 then it will give this months 2nd

Hi mohana,

thanks once again . [;)]

Welcome [:D]

hai,

consider my Current Date (Today) is 17-10-11 (current date is my reference date on which Date formule are used)

If I give 1D then it adds one day to my current date and gives a result 18-10-11

If I give 2D then it adds two days to my current date and gives a result 19-10-11

If I give D1 then it gives the start date of next month that is 1-11-11 (basing on the date)

If I give -D1 then it gives the start date of current month that is 1-10-11

suppose if my current date is 1-10-11 then

If I give D1 then it gives the date 1-11-11

if i give -D1 then it gives the date 1-09-11

it means that the dateFormula D1 returns the next date which having date 1 (if it is D2 returns the next date which is having date 2)

if negitive sign is given it is reversal means shows the past dates

------------------lets consider another Date As current date

current date is 09-03-11 (9th of march)

if i give 15D then it adds up 15 days to my current date and gives result date 24-03-11

if i give D15 then it gives next date which is having date 15 that is 15-03-11

----------suppose current date is 16-03-11 (16th of march)

then if i give D15 to current date the result will be 15-04-11

thank u