Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two fields that are the start_date and end_date in the format mm/dd/yyyy
How do I calculate the time in days between the two? Can someone tell me the code to do this?
Mallika,
Just subtract those dates. like end_date- start_date
if they're not in date format then , Date#(end_date,'mm/dd/yyyy') - Date#(start_date,'mm/dd/yyyy')
Good luck!
Avinash
end_date-start_date or if timestamp Interval(end_date-start_date,'D')
Mallika,
Just subtract those dates. like end_date- start_date
if they're not in date format then , Date#(end_date,'mm/dd/yyyy') - Date#(start_date,'mm/dd/yyyy')
Good luck!
Avinash