Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to differentiate between two dates which are in timestamp format and display the difference value in "Days"
Example:-
Field 1 = 4/11/2013 12:40:36
Field 2 = 4/16/2013 12:00:00
Difference value should be "5 days". Any idea?
Hi,
Try this.
Interval(Field2 - Field1 ,'D') as Diff_in_Days.
Regards,
Kaushik Solanki
Hi,
I think this is the duplicate post, anyway try like this
=Ceil(Interval(Date#('4/16/2013 12:00:00', 'MM/DD/YYYY hh:mm:ss') - Date#('4/11/2013 12:40:32', 'MM/DD/YYYY hh:mm:ss'), 'DD' ))
Hope this helps you.
Regards,
Jagan.
Try this example app...