Date Picker Month Format Seems inconsistent

[thering1975TG]

Hi All

So i am playing around with charts etc to get an understanding of how that part all works, which led me to find something i cannot work out how to resolve.

I will split this in to the work flow to show where i am seeing the Issue, all based on internal CouchDB

Form

Let's say the first field is a date picker no time in a form block. When you select for example 1st January 2024, this will save in the internal DB as:

• Jan 1 2024

Yet in the form it will show as January 1st, 2024

Now let's go create a view and add a filter by date:

Column = Date
Equals
Value

Now as the column is setup as Date in the DB, you get the same date picker, click on this and select 1st January 2024

This now gives you a result of:

• January 1, 2024

As such the two date formats do not work or match so no results are shown, this is the same when using the date picker in the fron end to filter reults in a table as obviously nothing matches

I cannot see on the form design section where i can set the date format to be recorded, but surely it should follow the same format throughout the system?