Skip to main content

Using Duration in a formula for an end date

  • August 29, 2022
  • 1 reply
  • 4 views
C
Forum|alt.badge.img+2

Hi Everyone,

I have a start date field and a duration type field and I’m trying to create an end date with a formula
DATEADD({ :gear: Appointment Start Date},{Duration},‘minutes’)

This doesn’t seem to do anything i.e. the end date is the same as the start.

Any ideas?

Cheers

    1 reply

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • August 29, 2022

    Duration fields (versus number fields) store their values as seconds, not minutes, so I would expect to see

    
DATEADD({:gear: Appointment Start Date},{Duration},'seconds')

    However, that does not explain why you are not seeing a different date.

    Are both of your fields set to show time as well as date?

    Are both fields formatted with the same timezone setting?

    Screen captures could also help in figuring out this issue.


    Terms & ConditionsAccessibility statement