Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
1 Solution

Accepted Solutions
PrashantSangle

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

11 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion III
Champion III

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
Creator III
Creator III
Author

.

xyz1
Creator III
Creator III
Author

.

xyz1
Creator III
Creator III
Author

.

PrashantSangle

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
Creator III
Creator III
Author

.

Anil_Babu_Samineni

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

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

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,