You are reading a single comment by @NotThamesWater 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).

  • Fuck knows how or why.

    Because excel and dates. erryteim.

    Oh - it won;t be consistent either. Sometimes it will have transposed them, others it won't.

    It could have crept in at any time -from opening a csv, saving a csv, importing a value, copying & pasting...

About