convert DD.MM.YYYY to YYYY/MM/DD

[TomBond77]

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

[dwforest]

if the leading 0 of 0PSTING_DATE is not there the date format would be D.M.YYYY

[rwunderlich · Accepted solution]

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