Forum Discussion
Solved
Day function reading month
Hi, I'm using a DAY function to read the day out of a column with the date in dd/mm/yyyy format. However when the day is 12 or below the function reads the month instead, as you can see in the pictu...
That does seem odd. What data time are you using for the [ZAPPDATE] column?
And if you are using Date/Time what does your [ZAPPDATE] column show if you set the Format to something a little more verbose?
Thanks! The trick was to change the format outside of the query-editor.
That does seem odd. What data time are you using for the [ZAPPDATE] column?
And if you are using Date/Time what does your [ZAPPDATE] column show if you set the Format to something a little more verbose?
Thanks! The trick was to change the format outside of the query-editor.