date calculation

  • Resolved civilvicky

    (@civilvicky)


    3 years, 1 month ago

    Is it possible to get the date 100 days from today. For example if we have one date field in which by default the date will be current date. Another field will be calculated field where the date will be shown that is 100 days earlier from the current date.

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

    (@codepeople)

    3 years, 1 month ago

    Hello @civilvicky

    To get 100 days from today, you can insert a calculated field in the form and enter the equation:

    GETDATETIMESTRING(DATETIMESUM(TODAY(), 'dd/mm/yyyy', 100, 'd'), 'dd/mm/yyyy')

    If instead of using the TODAY operation, you want to increase the value of the date field fieldname1, the equation would be simpler:

    CDATE(fieldname1+100,'dd/mm/yyyy')

    To get earlier 100 days, the corresponding equations would be:

    GETDATETIMESTRING(DATETIMESUM(TODAY(), 'dd/mm/yyyy', -100, 'd'), 'dd/mm/yyyy')

    and 

    CDATE(fieldname1-100,'dd/mm/yyyy')

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘date calculation’ is closed to new replies.