topic Re: how to change two different type of date format? in QlikView

?

xyz1 — Sun, 14 Apr 2019 13:50:06 GMT

Re: how to change two different type of date format?

Anil_Babu_Samineni — Fri, 10 Mar 2017 05:14:43 GMT

What was the issue here

And title you mentioned may be try this?

Date(Date#(Date1, 'MM/DD/YYYY hh:mm:ss TT'),'DD-MM-YYYY') as Date1,

Date(Date#(Date1, 'MM/DD/YYYY hh:mm:ss'),'DD-MM-YYYY') as Date2

Re: how to change two different type of date format?

vinieme12 — Fri, 10 Mar 2017 11:23:03 GMT

like below

LOAD if(findoneof(Temp,'/')>0,Timestamp(Timestamp#(Temp,'M/DD/YYYY h:mm:ss TT')),Timestamp(Timestamp#(Temp,'mm-dd-yyyy hh:mm:ss'))) as StandardTimestamp Inline [

Temp

2/27/2017 12:39:36 PM

03-06-2017 13:16:24

];

?

xyz1 — Sun, 14 Apr 2019 13:47:15 GMT

?

xyz1 — Sun, 14 Apr 2019 13:48:42 GMT

?

xyz1 — Sun, 14 Apr 2019 13:46:05 GMT

Re: how to change two different type of date format?

PrashantSangle — Tue, 14 Mar 2017 06:06:12 GMT

Hi,

check alt() in help menu. It will help you to deal with different types of date format in one column.

Syntax:

alt( date#( dat , 'YYYY/MM/DD' ),

date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'MM/DD/YY' ),

'No valid date' )

Modify format as per your format.

Regards,

Prashant

?

xyz1 — Sun, 14 Apr 2019 13:46:36 GMT

Re: how to change two different type of date format?

Anil_Babu_Samineni — Tue, 14 Mar 2017 06:35:10 GMT

You can check now, We've control of AM and PM at the same time

Re: how to change two different type of date format?

Anonymous — Tue, 14 Mar 2017 06:56:29 GMT

Hello,

if(len(trim("Last Logon Time Stamp")) <> '0',

if(isnull(date(floor(trim("Last Logon Time Stamp")))),date(date#("Last Logon Time Stamp",'M/DD/YYYY h:mm:ss TT'),'MM/DD/YYYY'),

date(floor(trim("Last Logon Time Stamp")),'MM/DD/YYYY'))) as date,

Re: how to change two different type of date format?

PrashantSangle — Tue, 14 Mar 2017 07:01:47 GMT

Hi,

In 1st it is not possible tell which format.

01/09/2015

We can not say is this 1st sept 2015 or 09-Jan-2015

In this case you consult with your data entry operator.

In 2nd case you can easily say it is (MM/DD/YYYY hh:mm:ss TT) format

Regards,

Re: how to change two different type of date format?

vinieme12 — Tue, 14 Mar 2017 07:02:33 GMT

please post some sample data, as you can see it works with the sample i posted