Events Booking Date Fields, Create separate Format when exporting records.

  • David Unwin
  • David Unwin's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
7 months 3 days ago - 7 months 3 days ago #156787 by David Unwin
In the configuration for Events Booking you can set a date format for the Event Date Field.  We have ours set to 'l, jS F, Y  g:i a' This produces nice looking dates for our users ie Monday 1st January, 2023 10am.

However, Setting the Event Date Field to 'l, jS F, Y  g:i a' or leaving blank (default) creates a problem when you want export and analyse your registration records say using EXCEL as the date fields are all exported as TEXT fields and you cannot do computations against these date fields ie Extract the Month or Day or hour from the Event Date Field

You can resolve this by setting  the Event Date Field format to Y-m-d H:i:s. Then the date fields are exported in a format that you can do computations against the Date Fields.
However, If we  set the Event Date format field to Y-m-d H:i:s it shows on our events with a US Format ie 2023-01-01 10:00:00 which is US format, we are in the UK. It also does not look nice.
What is required is an extra config field where you can set the Event Date Field for Export to Y-m-d H:i:s for export purposes and leave the Events Date format to  display events as default or the user's set value
This would allow your to keep your dates in the format you want for display, but also allow you to to perform analysis by date functions on your registration records 
Last edit: 7 months 3 days ago by David Unwin.

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc