topic Date & Time format in QlikView

Date & Time format

Mon, 25 Jan 2016 06:19:12 GMT

Hi,

Can any one help me to convert Date & Time format.

Few values are recognized as date & time. How to convert every thing to make into qlik readable format,

where I can use expressions like difference between 2 dates and between time.

Regards,

Pavan.

tresB — Mon, 25 Jan 2016 06:23:34 GMT

Date(Floor(Alt(Timestamp#(Call_Date, 'MM-DD-YYYY hh:mm:ss'),

Timestamp#(Call_Date, 'MM/DD/YYYY hh:mm:ss TT')))) AS Call_Date

Time(Frac(Alt(Timestamp#(Call_Date, 'MM-DD-YYYY hh:mm:ss'),

Timestamp#(Call_Date, 'MM/DD/YYYY hh:mm:ss TT')))) AS CallTime

jagan — Mon, 25 Jan 2016 07:15:59 GMT

Hi,

Try like this using Alt()

Alt(Timestamp#(Call_Date, 'Format1'), Timestamp#(Call_Date, 'Format2'), Timestamp#(Call_Date, 'Format3'))

Note: In the above replace Format1, Format2,.. with your timestamp formats.

Hope this helps you.

Regards,

Jagan.

MK_QSL — Mon, 25 Jan 2016 10:25:29 GMT

	TimeStamp(Alt(TimeStamp#(Call_Date,'DD-MM-YYYY hh:mm:ss'),TimeStamp#(Call_Date,'M/DD/YYYY h:mm:ss TT'))) as Call_DateTime,
	Date(Floor(Alt(TimeStamp#(Call_Date,'DD-MM-YYYY hh:mm:ss'),TimeStamp#(Call_Date,'M/DD/YYYY h:mm:ss TT')))) as Call_Date,
	Time(Frac(Alt(TimeStamp#(Call_Date,'DD-MM-YYYY hh:mm:ss'),TimeStamp#(Call_Date,'M/DD/YYYY h:mm:ss TT')))) as Call_Time

Anonymous — Mon, 25 Jan 2016 10:40:18 GMT

Data which appears into left side is String....

To convert it into number do like this?

=date(date#(DateField,'DD/MMM/YYYY hh:mm'),'DD/MMM/YYYY hh:mm')

Similarly for your time replace date with Time or Timestamp.

For Difference b/w Date & Time, check this?