Forum Discussion

LillyD's avatar
LillyD
Frequent Visitor
8 years ago

Change Date format in Query Editor

Hi,    I am trying to change the date format of a column in query editor from the AM / PM (highlight) values shown below.       If i change the column to Date/Time it errors as below    ...
General Comment
Need Help
Tutorial Requests
Alwyn1991's avatar
Alwyn1991
Frequent Visitor
6 years ago

LillyD  have you tried in Query editor to replace the values i.e replace AM with blank the next step replace PM with blank then next step change the type?