Skip to main content
Solved

Form Showing Incorrect Date Format

  • June 3, 2022
  • 4 replies
  • 51 views

Forum|alt.badge.img+4

I have recently set up a form so that our customers can make booking based on available meeting times.
Everything was working fine and suddenly the Time format on the form view has changed from DD/MM/YY hh:mm to yyyy-mm-ddThh:mm:ss.sssZ

I am unsure why the format has changed and how to amend it back to the original.

Many thanks in advance for any help you may offer

Best answer by Jesse_Lauer

Hey Jesse, apologies, I’m having a hard time visualizing this. Could you attach a screenshot of the issue please?

Once I fully understand the problem I’ll be able to provide suggestions


I ended up creating a new column for the date field and creating a formula field for the DATETIME_FORMAT()

had to change a few links around to correct my calendar views but looks to be all sorted now

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hey Jesse, apologies, I’m having a hard time visualizing this. Could you attach a screenshot of the issue please?

Once I fully understand the problem I’ll be able to provide suggestions


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • Answer
  • June 3, 2022

Hey Jesse, apologies, I’m having a hard time visualizing this. Could you attach a screenshot of the issue please?

Once I fully understand the problem I’ll be able to provide suggestions


I ended up creating a new column for the date field and creating a formula field for the DATETIME_FORMAT()

had to change a few links around to correct my calendar views but looks to be all sorted now


TheTimeSavingCo
Forum|alt.badge.img+31

I ended up creating a new column for the date field and creating a formula field for the DATETIME_FORMAT()

had to change a few links around to correct my calendar views but looks to be all sorted now


Glad you got it sorted!


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • June 3, 2022

Glad you got it sorted!


Thanks Adam, appreciate your response :slightly_smiling_face: