You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • Also I've been given a report to query but in any month where the day is 1-12 the day and month have been transposed.

    Fuck knows how or why.

    There must be a clean up formula that can fix this into a new column?

    (There is, it is pretty neat).

  • That's probably your locale setting. It's US dates not being properly recognised.

About

Avatar for aggi @aggi started