Custom Field - Date Format

[10RUPTiV]

I would like to have a custom field using a date with the calendar icon too.

 

In the database it need to be a real date field not only a text one.

 

It would be usefull to set a date reminder in an account for a contract renewal for example.

 

[Tyson]

Is there a particular reason you need the database to use a date type rather than the current text type?

[10RUPTiV]

First, to have the calendar popup to make sure "date" are all in the same format

 

Also, to be able to eventually, trigger something to send an email based on this date!

[Michael]

Is there a particular reason you need the database to use a date type rather than the current text type?

 

If this was for client fields that would be nice to have to ensure the date of birth was a date in the format we like.

[10RUPTiV]

We need this to help us managing "renewal date" for contract or P.O.

 

We have some clients that we need each 6 or 12 months to negociate a new contract and a new P.O. and some others clients to just re-ask for a new P.O. for the next year.

[Tyson]

First, to have the calendar popup to make sure "date" are all in the same format

 

Also, to be able to eventually, trigger something to send an email based on this date!

Ah. I thought you were referring to the database schema needing a MySQL date or datetime type.

 

Sending emails based on custom fields may be better suited to a custom plugin.

[10RUPTiV]

Is it possible to have this in a plugin or you need to do that in the core ?

[Tyson]

Supporting formatted custom client date fields could likely be in the core, I speculate, but having an email sent based on the value of certain custom fields is better suited to a plugin.