Date difference

mrigya

Hi All
Please tell me how can i calculate the date difference and convert that difference to date formula type .

Like as if i have two date
26/05/08 and 28/05/08, i want the ouput like..2D...their difference in the dateformula type.

Thanks
Mrigya

garak

Do you mean following like this :?:

Date2 := 31122008D;
Date1 := today;
evaluate(DateFormulaVar,'<' + format(Date2-Date1) + 'D>');
Date3 := CALCDATE(DateFormulaVar,Date2);

mrigya

Thanks a ton...

garak

Please, so please write [Solved] infront of the subject in your first post.

Regards