Forum Discussion
cdn4lf
6 years agoFrequent Visitor
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
- 6 years ago
I figured this out. I had to convert at the query level, not at the design level.
cdn4lf
6 years agoFrequent Visitor
Is there a way to do this without needing to add a new column? I was hoping for a workaround that would allow me to convert to date format.
If I have to resort to coding, I can, but this affects multiple columns across a large number of tables.
Thank you,
cdn4lf
6 years agoFrequent Visitor
I figured this out. I had to convert at the query level, not at the design level.