topic Re: Date format in QlikView

Date format

Anonymous — Fri, 03 Aug 2018 11:51:38 GMT

Hi all i have date format like 22/04/2018 i want show this 18-22-04 any help

tresB — Fri, 03 Aug 2018 11:55:37 GMT

Date(Date#('22/04/2018', 'DD/MM/YYYY'), 'YY-DD-MM')

Edit: Corrected the format. Thanks Jacob.

sibin_jacob — Fri, 03 Aug 2018 12:09:05 GMT

Please try the below one.

A small change from Tresesco's expression.

Date(Date#('22/04/2018', 'DD/MM/YYYY'), 'YY-DD-MM')

Anonymous — Fri, 03 Aug 2018 14:06:27 GMT

thanks its working