The data from the source contains one column of dates in a European (DD/MM/YYYY) format.
I want to convert this column into an American (MM/DD/YYYY) format.
I've tried the following:
Create an Excel table of two columns--one containing all dates in the year 2020 in an American format and one containing the dates in a European format. I then imported this file, created a custom column using a Lookup function to match the original date from the source with the instances in the European column and print out the matching result from the American column.
But this workaround doesn't work because when Sisense pulls in the Excel file, it reformats all dates in an American format, causing the result column to just readout the same dates in the same format as the source.
Please sign in to leave a comment.