total days in between two dates

[Anonymous]

hello

how to find total days in between two dates?

thank you

[craigsutton]

Since dates are stored as dual both number and date, you can subtract the end date from the start get and use the floor function to get total number of days between two dates.

Floor(Num(DateEnd-DateStart))

[Anonymous]

thanks craig..

i come to know one thing, i have only one date field and want find total sales between two date ?

[vishsaggi]

You mean your End date should be something like Today()?

[sergio0592]

You can enter your dates in variables (V_Start_date, V_End_date) with two input box.

Expression=sum({<[Sales date]={">=$(=Start_date) <=$(=End_date)"}>}  Sales)

[Anonymous]

yes

[vishsaggi]

You want this in Script? Just extending Craig's expression you can try like:

Num(Floor(Today() - StartDate)) AS DaysDiff