I want a date field in the format dd-mm-yyyy that can be set by the user and later cleared by the user.

I have tried using the Date field type but I can't get it to work using dd-mm-yyyy. Using this format the date is not changed when saved. (It works OK using yyyy-mm-dd). I am not using the Unix format as I understand that a blank Unix date is not valid.

I have tried setting the format in the field and on the form but cannot find a combination that works.

Any help please?

I am testing in the sandbox using Joomla 3

Thanks
Trevor

Strange. It is working for me.
Tests are complex because it can depends of many things.

1. What type are you using ? Date, Time, Datetime ?
2. Witch PTL ? Project Table Layout
3. Are you using another date with opposite format : mm-dd-yyyy

Because the component is decoding the string format and when you are using both dd-mm-yyyy AND mm-dd-yyyy it can conflicts because it cannot make difference between the 2 formated strings.

I wll check you project.

Dates are complex when multiples formats are used in the same component.
In future I want to reduce to only ONE date format for whole component and translatable in language file.

I have created a simple demo project called Date Test. There are two Date fields:
default_format which has the date format left as Inherit
ddmmyyyy_format which has the format set to dd-mm-yyy

I have a form using the two fields and the format of the fields are Inherit. When a date is selected only the data in the default_format is saved. No errors are displayed.

I have tried several combinations and formats but without success so far - I think I am missing something )

Trevor

Fixed.

Changed files :
concerned models : save() function
helpers / dates.php : getSqlDate() improved