Back with another date formatting question 😞
My data source is an Excel file within a Sharepoint list. I have a connection to the SharePoint which refreshes daily to reflect any changes.
Within the Excel file there are 5 date columns, 3 of which I was successfully able to format. One of my columns [Authorised] is in a 'mm/dd/yyyy hh:mm' (the same as the 3 working columns) format within Excel, but when reading it in Qlik Sense any items within the column appear blank. This is the same for the one other remaining column.
I've tried date# and timestamp# but to no success 😞
any ideas would be greatly appreciated as always
