Date time

  • Resolved edenb

    (@edenbuganim)


    5 years, 11 months ago

    Hi dear support,
    I’m trying to create a calculator.
    I make a return date less a departure date * value from dropdown(i make value “1” “2” “3”)

    i just do this:
    abs(fieldname3-fieldname2)*fieldname6

    fieldname3 – is return date
    fieldname2 – departure date
    dropdown – have 3 opthins(value: 1,2,3).

    the problem with Calculated Field, i dont know why but the default number is “18420”
    thanks!

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    5 years, 11 months ago

    Hello @edenbuganim

    These value is the number of days from 1 January 1970

    The correct equation would be:

    
IF(AND(fieldname2,fieldname3), abs(fieldname3-fieldname2)*fieldname6, '')

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Date time’ is closed to new replies.