Solved: Re: how to change two different type of date forma... - Qlik Community

xyz1 · ‎2017-03-10

.

PrashantSangle · ‎2017-03-14

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

Anil_Babu_Samineni · ‎2017-03-10

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-03-10

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

];

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

xyz1 · ‎2017-03-14

.

xyz1 · ‎2017-03-14

.

xyz1 · ‎2017-03-14

.

PrashantSangle · ‎2017-03-14

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

xyz1 · ‎2017-03-14

.

Anil_Babu_Samineni · ‎2017-03-14

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-03-14

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,