Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Date reversed when parsed

Hi all,

I have a little problem with my date creation for an app.

I have .csv file, with a field that represent a timestamp, for example "01-09-2016  07:49:00".

I try to create a date field on my script like this :


date(ceil("Time"), 'DD-MM-YY') as "Date"

But when I use my field date on a dashboard I get something like "16-09-2001". The date is reversed and I don't know what I do wrong.

Can someone help me please?

Thank you in advance.

1 Solution

Accepted Solutions
Highlighted

Re: Date reversed when parsed

Try this:

Date(Floor(Date#(Time, 'DD-MM-YYYY hh:mm:ss'))) as Date

View solution in original post

2 Replies
Highlighted

Re: Date reversed when parsed

Try this:

Date(Floor(Date#(Time, 'DD-MM-YYYY hh:mm:ss'))) as Date

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Date reversed when parsed

It worked.

Thnak you.