Hi Guys i tried this format but its not working what im doing wrong?
[=FD(’{TICKET DATE}’,‘dd/MM/yyyy’)]
Take the slashes out ddMMyyyy
LOL i found the solution i was wrong with these symbols ’