Forum Discussion
Solved
Converting Date Format
Hi All, I am trying to convert yyyy-MM-ddThh:mm:ss to yy-mm-dd. Any help would be appreciated. Thank you! Sean
I figured this out. I had to convert at the query level, not at the design level.
What I did was first converting the data to date so for that I created an additional column with the formula "Date = Left(DateTimeColumn,10), then convert the date to whatever format you want in the Column tools, Data Type- Date and Format to the one you want.