Day function reading month

[Luddekudde]

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 picture.

The column [days in between] reads the [ZAPPDATE] with a DAY function, but when the day value equals 12 or lower it instead reads the month value.

I have my dateformat set to dd/mm/yyyy on my computer so that shouldn't be the problem. Any ideas?

Thanks

[Phil_Seamark · Accepted solution]

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?

[Phil_Seamark · Accepted solution]

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?

[Luddekudde · Accepted solution]

Thanks! The trick was to change the format outside of the query-editor.