Forum Discussion
Solved
Column formatting dates broken - or am I going mad?
Hi, I noticed that some of my column's formatting (background colour fills depending on date) was returning odd colours. As I was using my own JSON code I decided to clear out the code and just ...
- Ah, fixed the issue. It was indeed the way that I had written the calculated column formula, to get around another issue I had wrapped the DATE function in TEXT, this was causing the dates to be read as MM/dd/yyyy rather than the correct dd/MM/yyyy. Thanks for the pointer ganeshsanap
ganeshsanap, good idea, I think that is what is happening. I need to work out why this is happening now, the regional settings for the site are correct. I guess the calculated column formula is doing something odd with the dates, although it should be formatting them as dd/MM/yyyy.
Ah, fixed the issue. It was indeed the way that I had written the calculated column formula, to get around another issue I had wrapped the DATE function in TEXT, this was causing the dates to be read as MM/dd/yyyy rather than the correct dd/MM/yyyy. Thanks for the pointer ganeshsanap