Date format

[Anonymous]

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

[tresesco]

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

Edit: Corrected the format. Thanks Jacob.

[sibin_jacob]

Please try the below one.

A small change from Tresesco's expression.

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

[Anonymous]

thanks its working