ConfiForm Date Field saving wrong data

[Maximilian Neufeld]

Hey there,

so I have the following problem:
In my Form I have a field "field1" with the type "Date". As formatting pattern I set YYYY.MM

Whenever someone fills the form it saves a "wrong" date.... So e.g: 

I pick 2025.08 then the saves entry says 2025.12

If I pick 2025.03 the record says 2025.01. 

It seems like somehow the date gets rounded to either month 12 of the year or month 1....

Did anyone experience that before?

Greetings Max

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Maximilian Neufeld 

Have a look what YYYY pattern means in a date/time field https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html

It is far from what you want/expect I afraid...

Alex

[Maximilian Neufeld]

Thanks Alex - I replaced it with yyyy and it works.