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 regional date format. The math column would always give you YYYYMMDD. But then again, I may have missed the entire point of this whole conversation.

5 Likes