Feature proposal #6589
closed
Implement parsing of date fields into storeable values
Added by krileon about 7 years ago.
Updated over 6 years ago.
Description
Currently social sites may not provide standard SQL formatted dates. Run them safely (try catch) through date parsing to format as SQL values so they can be properly stored.
This probably should be done on a provider by provider basis with a function to simply treat certain profile variables as dates and handle the conversion at once.
Maybe instead of forcing this for every date field simply provide an additional field mapping usage of formatted. Example options as follows.
birthday
birthday (Formatted)
Where (Formatted) usage would be formatted to SQL date.
Best solution is to simply check what type of field is attempting to be mapped and format accordingly (e.g. if something is being mapped to a date field ensure it's formatted for a date field).
- Status changed from Assigned to Resolved
- % Done changed from 0 to 100
If a value is mapped to a date or datetime field it will not attempt to convert it to SQL safe.
- Status changed from Resolved to Closed
Also available in: Atom
PDF
Updated by