Data table | How can I format a Date?

Christina_108366
Christina_108366 Posts: 37
edited October 2020 in Questions

How can I format a 'table' field as DD.MM.YYYY?

I have uploaded an empty table in preparation for a webform. I want some columns to be prefilled with a date in a special format, so I have entered some values. However, it is not possible to get the correct format for these values, even though I have edit the field as you see:

Answers

  • Kalin_996882
    Kalin_996882 Posts: 74 admin

    Hi Christine,
    The Date field type has only a few default formats:

    • 1/1/20200
    • 1/01/2020
    • Jan 1, 2020
    • January 1, 2020

    To format your date to something more custom you can use Dates: Format a Date Time.

    In my example below, I use the action Date-times: Get Current Date & Time to get a field with today’s date. Dates: Format a date time then formats the date to DD.MM.YYYY (see action configuration). The formatted date is then added to my table with Tables: Add a row.

    Let me know if this helps and if you have any questions.

    Thank you!


    Dates: Format a Date Time

    https://help.catalytic.com/docs/dates-format-a-date-time/

  • Hello Kalin,
    thank you very much, but this doesn't help me with my problem.
    I need this table in a webform and I want the users of the webform to be able to enter a date in german format (DD.MM.YYYY).
    And in the configuration of the table (edit field) I can select this format, as you can see in the screenshot above. But this configuration doesn't affect the table.

  • @Veronika_128563 : Could you help me here?