Changing format of output date

  • Resolved limarob

    (@limarob)


    1 year ago

    Hi

    I have a really simple calculator where I take a user’s selected date and show a date 49 days before it. This is the equation I am using:

    DATETIMESUM(fieldname3, ‘dd/mm/yyyy’, -49, ‘d’)

    At the moment the output has the time in it and also displays day of the week. I would just like it to display the result as dd/mm/yyyy

    Thanks

    Rob

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

    (@codepeople)

    Hello @limarob

    Thank you very much for using our plugin.

    DATETIMESUM operation returns a date object, and you must use the GETDATETIMESTRING operation to transform it into a text with date format as follows:

    GETDATETIMESTRING(DATETIMESUM(fieldname3, 'dd/mm/yyyy', -49, 'd'), 'dd/mm/yyyy')

    However, if fieldname3 is a date field, the process is simpler:

    CDATE(fieldname3-49, 'dd/mm/yyyy')

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Changing format of output date’ is closed to new replies.