convert date automatically to 31.12.XXXX

  • Resolved psc7

    (@psc7)


    4 years, 8 months ago

    Hey guys,
    I got the following problem:
    The user insert a date like 23.09.2024. Now the calculator should transform the date to the end of the year (31.12.2024) automatically.
    Is there any solution for this problem?
    Kind regards
    Per

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

    (@codepeople)

    4 years, 8 months ago

    Hello @psc7

    Assuming you are using the latest update of the plugin, and the date/time field is the fieldname1, the equation would be:

    CONCATENATE(31,'.',12,'.',YEAR(fieldname1))

    or using the plus operator:

    31+'.'+12+'.'+YEAR(fieldname1)

    Best regards.

    Thread Starter psc7

    (@psc7)

    4 years, 8 months ago

    Great, Thanks a lot!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘convert date automatically to 31.12.XXXX’ is closed to new replies.

Tags