Cannot find a universal way to input Date formats via Data Grid Builder

Summary:

Hi,

We are working with data grid builder in groovy rules.

We need to upload today's date once a modification is performed.

Though, we are noticing different behaviors based on user's preferences settings when speaking of date format.

If a user selects "Automatically Detect" in the display option, then the grid builder works fine and loads the correct date (let's say 06/21/2024).

If a user instead selects a date format which differs from the default one (MM/dd/YYYY), like for instance dd/MM/YYYY, then the system somehow reads today's date as 21/06/2024, where 21 is read as the month, and thus results in 09/06/2025 date upload.