topic Re: DateTime Format in QlikView

DateTime Format

Fri, 02 Oct 2015 07:17:28 GMT

Hi,

I'm trying to pull out the following:

load Timestamp#(max(Timestamp), 'DD/MM/YYYY hh:mm:ss')as maxTS
Resident ObsExportQVD;

However the result outs out as 42278.535208333 instead of '2015-10-02 08:10:15' for example.

I have also tried the following, and it bring outs the date in the correct format only. I need the time to come out as well.

load Date(max(Timestamp))as maxTS
Resident ObsExportQVD;

Any ideas how I can get around this?

Thank you.

simenkg — Fri, 02 Oct 2015 07:26:51 GMT

Just use

Date(max(Timestamp),'DD/MM/YYYY hh:mm:ss) as maxTS

PrashantSangle — Fri, 02 Oct 2015 07:28:57 GMT

Hi,

Use timestamp() instead of Timestamp#()

Regards

maxgro — Fri, 02 Oct 2015 07:38:26 GMT

if you want date use Date formatting function

load Date(max(Timestamp)) as maxTS
Resident ObsExportQVD;

if you want timestamp use the Timestamp formatting function

load Timestamp(max(Timestamp)) as maxTS Resident ObsExportQVD;

or add a format as second param in Timestamp

load Timestamp(max(Timestamp), 'the format you want') as maxTS Resident ObsExportQVD;

Fri, 02 Oct 2015 11:14:19 GMT

Thank you, this worked.

simenkg — Fri, 02 Oct 2015 11:38:29 GMT

Good!

Mark the answer as correct to close the thread.