How to calculate # no of days

[abc_18]

Hi,

I need to calculate a field called #days in Backorder.

field Order date is skey_date_order

So I can calculate the difference with today’s date, please suggest how can I achieve this?

Thanks

[petter]

Today()-skey_date_order

[thevingo]

Hi

try   Date#(Today(), 'DD/MM/YYYY') - Date#(skey_date_order , 'DD/MM/YYYY')

format DD/MM/YYYY depend on date format of field skey_date_order

You may have to change this.