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).
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...
@NotThamesWater started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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).