Mixed Dates and times in field

[spikenaylor1]

My source field contains the following date and time formats:

Nothing

DD/MM/YYYY hh:mm

DD/MM/YYYY

Date and Time Issues

I am struggling to get this into QlikView constistently

and loading it as is , the DD/MM/YYYY come in as possible string

Date and Time Issues 1

I am struggling to get all the dates loaded as dates and not strings

Can anyone help or point in the right direction

Regards

[Taoufiq_Zarra]

@spikenaylor1  Maye be :

Date(Floor(Alt(Num(Date#(DateField, 'MM/DD/YYYY')), Num(Date#(DateField, 'DD/MM/YYYY hh:mm')))), 'DD/MM/YYYY') as NewDateField

Example :

Data:

load *,
Date(Floor(Alt(Num(Date#(DateField, 'MM/DD/YYYY')), Num(Date#(DateField, 'DD/MM/YYYY hh:mm')))), 'DD/MM/YYYY') as NewDateField inline [
DateField
07/12/2020
04/12/2020
01/01/2021
24/12/2020 18:32
27/12/2020 11:56
]

output:

[Chanty4u]

Hi,

Have look at this .

https://community.qlik.com/t5/Qlik-Sense-Documents/Multiple-Dates-Using-Alt/ta-p/1493744