How do we find number of days between two dates

[#1]

Hi,

How do we find number of days between two dates,let suppose from 01/09/2014 to current date.

any suggestions

Thanks

[Anonymous]

date(date#('01/09/2014','DD/MM/YYYY') - today()

[avinashelite]

Hi Swathi,

Use networkingday() function

eg: networkingday(Startdate,enddate)

[MarcoWedel]

or

today() - date#('01/09/2014','DD/MM/YYYY')

to get a positive number of days

regards

Marco

[MarcoWedel · Accepted solution]

even

today() - '01/09/2014'

works, if the date string matches your DateFormat variable.