ISSUE: The date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in DOMO scheduled Reports.
I need them in text format and the correct should be the (e.g. 11-14-2023 10:00:00).
Some are appearing correctly but some are giving me in date format in the same column (see screenshot). Is this a known issue and is there any work around for this?
Ultimately, reason I’m reformatting is that when not changed, I get returned the “T” (e.g. 11-14-2023T10:00:00) which make it difficult to copy paste the data.
Let me know if clear. Thanks guys.
ETL Date Format:
ETL Change Column Type (did this because I thought it will force the column to be a text):