topic Re: Time stamp to date conversion in QlikView

Time stamp to date conversion

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to convert the date time stamp to date.

Please find below for reference:

Thanks..

marcus_sommer — Sat, 07 Jan 2017 13:47:11 GMT

You could use: date(floor(UPLIST_DATE))

- Marcus

nareshthavidishetty — Sat, 07 Jan 2017 14:01:55 GMT

Hi Marcus,

I have convert using date(floor(UPLIST_DATE)) but the dates are not selected correctly.

Please find below for reference.

Thanks..

marcus_sommer — Sat, 07 Jan 2017 14:22:32 GMT

Are there further selections in other fields?

- Marcus

vinieme12 — Sat, 07 Jan 2017 14:25:46 GMT

This should work, dI'd you have any other selections when taking this screenshot?

ADD AN EXPRESSION TO uplist _date list box

Isnum (uplist_date) and check if these are properdates

May have extra spaces or garbage character that we'll need to trim

alis2063 — Sat, 07 Jan 2017 15:19:16 GMT

Dear,

You can use alt function to get desired date format,

alt(
date#(DATE_FIELD,'MM/DD/YYYY'),

) AS date

MK_QSL — Sat, 07 Jan 2017 15:26:58 GMT

Date(Floor(TimeStamp#(UPLIST_DATE,'M/D/YYYY h:mm:ss tt'))) as Date

Time(Frac(TimeStamp#(UPLIST_DATE,'M/D/YYYY h:mm:ss tt'))) as Time

MarcoWedel — Sat, 07 Jan 2017 16:23:19 GMT

DayName(UPLIST_DATE) as Date

Hope this helps

Regards

Marco