topic Re: mix date format in Qlik Answers

mix date format

ddd111rgg23 — Mon, 21 Apr 2025 08:15:04 GMT

hello

i have date that show mix of format, i tried to use:

date(SUBMISSION_DATE,'DD/MM/YYYY') AS SUBMISSION_DATE,

what should i use to avoid this missing

thank you

Anil_Babu_Samineni — Mon, 21 Apr 2025 08:22:56 GMT

Make sure you have first converted all possible different formats into one. an example like below for 2 formats with date and num.

Alt(date(SUBMISSION_DATE,'DD/MM/YYYY'), date(Num#(SUBMISSION_DATE),'DD/MM/YYYY'), ...........)

marcus_sommer — Tue, 22 Apr 2025 10:41:37 GMT

It may not mandatory a matter of converting and formatting the dates properly else the data itself might be just invalid.

RobMika — Mon, 28 Apr 2025 03:50:19 GMT

What is your data source? Fix it there if possible.. Are those 3-digit entries valid?(What year is 0112?) or just some 'noise'.