Date Field

Home › Forums › Cascading dropdowns › Date Field

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
    • March 26, 2020 at 18:17 #29262
      HYM
      Participant

        Hi Alex, when using the cascade option in dffs on a date field i get the format as iso and it’s always late 1 day. any idea how to format the date field and fix the 1 day delay?

      • March 26, 2020 at 18:24 #29264
        HYM
        Participant

          attached screenshot of the date field format and it’s 1 day late

          Attachments:

          1. DateFormat.png

        • March 26, 2020 at 20:06 #29271
          Alexander Bautz
          Keymaster

            Hi,
            The date field is saved to the DB in ISO8601 format and the cascading dropdown reads this value and not the formatted date that is presented when you render the item in the form.

            To format the date like you want you must create a new calculated column in the list with a formula like this:

            =TEXT([YOUR_DATE_FIELD],"MM/dd/yyyy")

            And then use this new field in the Comma separated list of fields in the lookup list textarea.

            Alexander

        • Author
          Posts
        Viewing 2 reply threads
        • You must be logged in to reply to this topic.