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