days between start date and end date

[mhapanka]

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?

[dplr-rn]

end_date-start_date or if timestamp Interval(end_date-start_date,'D')

[achettipalli · Accepted solution]

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