topic Re: Timestamp to Date format, but not working. in QlikView

Timestamp to Date format, but not working.

Thu, 25 Jul 2013 06:38:43 GMT

Hi,

I have a super simple problem, but a problem nonetheless.

I have a field called newDate which I had converted from Timestamp format into Date format.

floor(oldDate) as newDate

But, tadaaaa, it gave me numbers instead: 41408.

I need to display the date in my textbox. I used the following expression but it doesnt work.

=date(date#(newDate, 'M/DD/YYYY'), 'DD/M/YYYY')

initially the format was in timestamp, like this: 5/14/2013 12:00:00 AM

any idea how to convert those numbers back to date format?

narender123 — Thu, 25 Jul 2013 06:41:50 GMT

Hi,

I think you need to do it as

=date(date#(newDate, 'MM/DD/YYYY'), 'DD/MM/YYYY')

OR IN SCRIPT LEVEL MAKE FILED AS

Date(yourdatefiled,'DD/MM/YYYY')

Thanks

Gysbert_Wassenaar — Thu, 25 Jul 2013 06:44:40 GMT

You can create the field like this in the script to give it a date format: date(floor(oldDate),'DD/MM/YYYY') as newDate

Or if you want to format it in an expression: date(newDate,'DD/MM/YYYY')

Or if you want to format it in a listbox, click on the Number tab, choose Date and enter DD/MM/YYYY as format string

Thu, 25 Jul 2013 06:53:47 GMT

thank you all, it works perfectly!

Fri, 10 Apr 2015 18:08:03 GMT

That was so helpfull!

Thanks!