QlikView App Dev

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.

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

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 · ‎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.

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

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 · ‎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,