Created Field Date format

[BobTerwilliger]

I created a date field in sugar, while I was in the English install. I've since put in the french language pack, and all dates seem to have switched over from mm/dd/yyyy to dd/mm/yyyy except for this field I created. I'm guessing its related to the language pack not being aware of this field.

Anyone know where these created fields are stored? I'm sure there is something there I can edit to change the format.

Thanks in advance!

[andopes]

I created a date field in sugar, while I was in the English install. I've since put in the french language pack, and all dates seem to have switched over from mm/dd/yyyy to dd/mm/yyyy except for this field I created. I'm guessing its related to the language pack not being aware of this field.

Anyone know where these created fields are stored? I'm sure there is something there I can edit to change the format.

Thanks in advance!

Hi Bob

Did you update the user date format from mm/dd/yyyy to dd/mm/yyyy?
The field definition is stored into table fields_meta_data and the field itself is stored into <module_table>_cstm.

Cheers

[BobTerwilliger]

Yeah, my bad. I was getting a date format error, and I was trying to enter in dd/mm/yyyy instead of dd-mm-yyyy. D'oh.

Usually helps when you enter in data correctly. Imagine that!

Thanks for the reply!