Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hari8088
Creator
Creator

Date format

Hi All,

Have some problem with date format.

I have tried with alt and date functions but am not getting perfect solution

want to show date with same format everything should be in timestamp fomat

I have attached my requirement below

3 Replies
sunny_talwar

Try this:

Temp:

LOAD Date,

  Date(Floor(Alt(Date(Date), Date#(Date,'MM/DD/YYYY hh:mm'), Date#(Date, 'DD/MM/YYYY hh:mm:ss TT')))) AS  DATE,

  TimeStamp(Alt(Date(Date), Date#(Date,'MM/DD/YYYY hh:mm'), Date#(Date, 'DD/MM/YYYY hh:mm:ss TT'))) AS  TimeStamp

FROM

source.xlsx

(ooxml, embedded labels, table is Sheet1);

hari8088
Creator
Creator
Author

it's working fine but in my case i am loading data from sql server there date format is same but few dates are in date format few are in text format means some dates are showing left side some dates are showing in right side in list box.

In this case your formula will work on that?

sunny_talwar

It should work, have you given it a try? If it doesn't work, please post a snapshot of raw date field to see what is not getting properly interpreted.

Why don’t my dates work?

Get the Dates Right