
Specialist
2019-12-18
05:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
convert DD.MM.YYYY to YYYY/MM/DD
Hi experts
need to convert posting date to YYYY/MM/DD. But the leading '0' of '0PSTNG_DATE) seems to be a problem. How shouldI solve it?
Date(Date#(0PSTNG_DATE, 'DD.MM.YYYY'),'YYYY/MM/DD') as [Invoice Date],
Many thanks
Tom
2,282 Views
1 Solution
Accepted Solutions


Partner Ambassador/MVP
2019-12-18
06:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field names that start with numbers must be enclosed in []
Date(Date#([0PSTNG_DATE], 'DD.MM.YYYY'),'YYYY/MM/DD') as [Invoice Date],
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
2,261 Views
2 Replies


Specialist II
2019-12-18
05:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if the leading 0 of 0PSTING_DATE is not there the date format would be D.M.YYYY
2,276 Views


Partner Ambassador/MVP
2019-12-18
06:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field names that start with numbers must be enclosed in []
Date(Date#([0PSTNG_DATE], 'DD.MM.YYYY'),'YYYY/MM/DD') as [Invoice Date],
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
2,262 Views
