Calculate date based on number

  • Resolved havsland

    (@havsland)


    1 year, 10 months ago

    I am trying to create a simple form but can′t find the correct way.

    I have af form with two fields. field 1 is a number field and field 2 is a calculated field.

    when a number is entered in field 1, I want to display a date in field 2 calculated as 1. january +/- the number of days entered in field 1.

    e.g. number entered in field 1 is 5= date displayed in field 2 displays 5. january
    and -5 entered in field 1 displays 27. december

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @havsland

    Thank you very much for using our plugin.

    Assuming the number field is the fieldname1, the equation in the calculated field can be implemented as follows:

    GETDATETIMESTRING(DATETIMESUM( '01/01/2023', 'dd/mm/yyyy', fieldname1, 'd'), 'dd/mm/yyyy')

    Best regards.

    Thread Starter havsland

    (@havsland)

    Thanks a lot. Exactly what I needed

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Calculate date based on number’ is closed to new replies.