pk
Contributor III
2021-12-06
07:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlikview date formats
Hello Team,
I have date format like- MM/DD/YYYY HH:SS:MM TT (e.g.- 12/06/2021 12:00:00 AM)
At scripting side, Want to pick/convert date into this format like 06-12-2021(DD-MM-YYYY)
Thanks in advance
440 Views
1 Solution
Accepted Solutions
Or
MVP
2021-12-06
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can format a date in any way desired using the date() function, e.g.
Date(YourDate,'DD-MM-YYYY')
Note that if your date contains a timestamp, you'll want to floor() it or apply dayname() to it first to get rid of the time stamp.
421 Views
1 Reply
Or
MVP
2021-12-06
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can format a date in any way desired using the date() function, e.g.
Date(YourDate,'DD-MM-YYYY')
Note that if your date contains a timestamp, you'll want to floor() it or apply dayname() to it first to get rid of the time stamp.
422 Views