I have a field in DateTime format. if the user choose today's date, the field will show "22/06/2001" but when i get the value from my code, it shows me "06/22/2001" as a result, i encounter an error when i do the following :
FromDate = Datenumber(Year(From), Month(From), Day(From))
I've checked the regional settings, the date format is "dd/MM/yyyy". is there any way that i can get the value of the date and force it to be formatted to "dd/MM/yyyy"?