Dynamic view - date format converting from UK to US

Dan Harris

Hi

Dates are being converted from UK format in the report to US format in dynamic view, cannot see anywhere in settings to change, can you help?

Thanks

Purnima Gore

Hi @Dan Harris

Yep, was a nightmare for me as well :-)

If you use a helper column for the date so for example start has the date, the helper column is called Start Date - use the formula =DateOnly(Start) and then use that in the dynamic view.

Choose this in the main view with the columns.

If you want make it editable (so you can change the date) show that in the data tab, and it will give you the UK version to change to but the view in the main sheet will be from the helper column.

All the best

Purnima