New Bug Encountered: Splitting Date weird behaviour

I’m having a weird behaviour from splitting my date by the “/” . It send back a list with my month and day switched around. Is there something about splitting dates that i’m not aware of?

AppSheet uses the date format as MM/DD/YYYY therefore when you split it, it’s listed the same way. What’s the unexpected behaviour here can you explain a bit further? Thnx.

1 Like

I was just confused as in my screenshot the dates value is 02/01/2018 and I expected the result of the split to be 2,1,2018 but it was 1,2,2018.

Use SPLIT(TEXT([Date]),"/") It will convert the date value to your own locale and then it should work.

1 Like