Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to get no of days days between two columns
data is in below format in both columns
1899-12-31 00:00:00:0
thanks
Can you provide your sample data or app?
floor(date1-date2) will give you difference in days
Regards,
Prashant
You can use interval()
try like
Interval(date1-date2,'D')
Regards
Hi Nagamani,
I think, straight away you can do (Date2-Date1) if both the columns are having same date format.
That all depends on how you want to represent the difference i.e in Days or Hours
it is not giving correct values, tried as below
this is gving wrong values when tried below
Interval(date1-date2,'D')
when trying to do d1-d2 it is giving some abnormal value as below, can you please help on this
try this..
=Ceil(Interval(Date(Date1, 'MM/DD/YYYY hh:mm:ss') - Date(Date2, 'MM/DD/YYYY hh:mm:ss'), 'DD' ))