topic Re: Date format issue in QlikView

Date format issue

viveksingh — Sat, 16 Nov 2024 04:45:06 GMT

Hi Experts,
I have date format in different formats for a column in a qvd. Like below
3/30/1999 12:00:00 AM
36531
5/4/1995 12:00:00 AM

How to conver to dd/mm/yyyy

Re: Date format issue

jonathandienst — Wed, 16 Jan 2019 05:51:17 GMT

Like this:

Date(Alt(Date#(myDateField, 'M/D/YYYY hh:mm:ss tt'), myDateField)) as DateField,

Re: Date format issue

jyothish8807 — Wed, 16 Jan 2019 06:01:05 GMT

Hi Vivek,

Try like this :

date(Alt(date#(Date,'MM/DD/YYYY hh:mm:ss TT'),
num#(Date,'#####'),
date#(Date,'DD/MM/YYYY hh:mm:ss TT'),
'NA')) as NewFiled

Re: Date format issue

viveksingh — Wed, 16 Jan 2019 06:31:59 GMT

Perfect. Thanks.