format date to dd/mm/yy regardless of windows settings

[222]

Thanks Titou

Tried it out with success...

[222]

thanks for your suggestion tst..... appreciate that

[tst]

I would like to make a correction. I made a quick test and it looks like modifying the design doesn't return the changed format in LV. Instead, what can be done is using the SQL command Format, which will output the date in the format you request.