mix date format

[dosaril]

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 · Accepted solution]

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]

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

[RobMika]

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

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download