I'm loading in an Excel file that has data set as date but for some reason, not all fields format, and this is then shown in the dashboard, even after forcing them as a date in properties.
Any idea on how I can force these dates to all be exactly the same?
Do you have any idea on how I can force either the excel file or qlikview to make it a standard date? I'm now having problems with it reading both UK and US date formats (making dates that should be read as 12-Jul-2018 and 07-Dec-2018 instead)?
Did you mean all the dates in 'DD-MMM-YYYY' format?
if(IsText(CreatedDate),Date(Date#(CreatedDate,'MM/DD/YYYY hh:mm'),'DD-MMM-YYYY'), Date(CreatedDate,'DD-MMM-YYYY')) as CreatedDate,