Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with date formats

Hi,

I wondered if someone can help me with this issue I am having with Date/Time fields I am importing into Qlikview from Excel.

I can't seem to get them all to convert to date time, I'm sure I must be doing something silly but I have been puzzling over this for hours now and can't figure it out. I have uploaded anonymised excel and qvw.

I hope someone can help!

Thanks,

Kate

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=Alt(TimeStamp([Ref Date/Time]), TimeStamp(Timestamp#([Ref Date/Time], 'DD/MM/YYYY hh:mm')))

View solution in original post

7 Replies
sacosta5
Contributor III
Contributor III

Hi Katy,

maybe...

=Timestamp#(Text([Ref Date/Time]),'DD/MM/YYYY HH:MM').

sunny_talwar

I have not looked at the sample, but I would not use MM (Capital Ms) for Minutes because MM are for Months and mm are for minutes

May be this:

=Timestamp#(Text([Ref Date/Time]),'DD/MM/YYYY hh:mm').

Clever_Anjos
Employee
Employee

Try this:

Ashford:

//CONCATENATE (Main)

LOAD 

timestamp(trim([Ref Date/Time]),'DD/MM/YYYY hh:mm') as [Ref Date/Time]

FROM [Testing.xlsx] (ooxml, embedded labels, Table is [$(m)]);

NEXT

sunny_talwar

Try this:

=Alt(TimeStamp([Ref Date/Time]), TimeStamp(Timestamp#([Ref Date/Time], 'DD/MM/YYYY hh:mm')))

View solution in original post

Not applicable
Author

Thanks so much Sunny, this works perfectly!!

Not applicable
Author

HI Katy,

You can use the following expression


=Timestamp(Timestamp#([Ref Date/Time],'DD/MM/YYYY hh:mm'),'DD/MM/YYYY hh:mm:ss')

I attach also qvw changed with the given expression

Regards

Gennaro

sunny_talwar

Awesome