
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DateTime Format
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.
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just use
Date(max(Timestamp),'DD/MM/YYYY hh:mm:ss) as maxTS

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Use timestamp() instead of Timestamp#()
Regards
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, this worked.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Good!
Mark the answer as correct to close the thread.
