Date Fiel displaying wrong format

Hello,
I have a form where one date field is not displaying correct. See the picture. I have changed the differente options for this date field and does not display correct data using combo box or without comb box. or using regional settings or without regional settings. Do not know why it display month and day in the year box.
Thank you for your help.

image

And these are the settings for this date field. DB is MySQL and I am using the latest version of Scriptcase.

play with sc_date_conv() macro to get this fixed

OK, will try that. I thought SC managed the format automatically, anyway, will try that. OnChange event I guess…

Thank you

Tried it but did not work (sc_date_conv() macro)… If I do not use combo boxes for the elements of the date, it works fine… I guess it is a bug it canno handle well data as combo boxes for month day and year.

what format on the database?

MySQL utf8_general_ci

I mean yyyy-mm-dd or something else and timestamp?

you have to change this into you database format