Forum Discussion
UK Date not Showing Correctly
For some reason it is putting the day in as the month. How would i get it to go the otherway round? Locale Settings are UK
I think you're going to have to give some sort of details of what you're talking about. What date, where, how...?
I up;loaded a pic but for some reason its not showing. will try again
In the calcodes column i have the code
calcodes = DATEVALUE("01"&"/"&[Month of the year]&"/"&[Year])For some reason it is putting the month of the year as the day.... any idea?
DATEVALUE takes your computer's locale settings for date order. Are you sure your locale settings are day/month/year and not month/day/year?
Checked the locale and it is showing dd/mm/yyyy.
So that doesnt seem to be the issue.