[solved] Convert Date Formula to Days in Report

madm

I wish to convert the time.lead times to a consistant type within a report. During setup, the user could have entered 1W, 7D, 1M, 30D etc so in a report I would like this to show 7, 7, 30, 30 etc etc so that a comparison can be made out of Navision.

Is there anyway to do it?

Thanks

Belias

MESSAGE('%1',CALCDATE('<1M>',010101D)-010101D);

Use your calcformula on a fixed date, then subtract the fixed date and you'll obtain the number of days of your calcformula

madm

Belias wrote:

MESSAGE('%1',CALCDATE('<1M>',010101D)-010101D);

Use your calcformula on a fixed date, then subtract the fixed date and you'll obtain the number of days of your calcformula

excellent it's worked exactly how i wanted it to!! Thanks