Date format locale struggle: sheet vs app

[Jeff_Hager]

Another alternative. I would simplify things by converting dates to a simple number with a math column and use those numbers to build relations linking the date number to the date number in the holiday sheet like @Darren_Murphy described. That way you have full control of the format and it’s completely stable without having to worry about different regional formatting. I explain it in the thread below. Only show the hint component if the relation is not empty. You should only need a math column and a relation column in addition to the date columns you already have.

Agent for information

I’m not following these date related threads very closely, so I’m not fully clear on what the issue is. I apologize if I’m way off track on this, but couldn’t you do a math column to make a numeric column in the format of YYYYMMDD, and then split that in the code and/or convert it to a valid date? If it’s for sorting, you wouldn’t even need to convert it to a valid date since the number would sort properly as a number or as a string. With this, there wouldn’t be a need to worry about the regi…