I have a strange problem with date.
I retrieved a value from another application as string which is supposed to be a date. But when I change it to date, it turns upside down!
For example, the value I retrieved is 20-09-04 where 20 is day, 09 is month and 04 is year. When I store it in a date variable, it turns to 9/4/2020. I even tried formatting it to "dd/mm/yy", but still the same. Please help.