You are viewing limited content. For full access, please sign in.

Question

Date/Time Difference

Forms Layout Designer Forms

Updated September 8

asked on September 8 • Show version history

Can someone guide me on getting the difference between two Date/Time fields in LF 12 modern design. I was thinking about converting each field using DateValue() but i think it doesn't include the time stamp. Anyway. Please refer to the pic provided.

Date Difference.png (5.08 KB)

| Download

0 0

Replies

replied on September 8

I got with my Var. They came up with this code and it work. And the result will be a single line field.

=FLOOR((EDT - SDT) * 24) & "h " & FLOOR(((EDT - SDT) * 1440) - (FLOOR((EDT - SDT) * 24) * 60)) & "m"

0 0

replied on September 8

I have used DATEDIF to calculate Dates, but it is limited to Months, Days or Years
=DATEDIF(start_date, end_date, time_unit)

=DATEDIF(DATE(2017, 1, 2), DATE(2017, 1, 14), "D") returns "12"

Also an Example on this POST
Calculate Age into YR/MO - Laserfiche Answers

For Time Calculations I have used the formula from the following post as an example
Calculating Working Hours - Timesheet - Laserfiche Answers

0 0

You are not allowed to follow up in this post.

Question

Question

Date/Time Difference

Replies

Sign in to reply to this post.