Feature proposal #6589
closed
Implement parsing of date fields into storeable values
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.
Updated by krileon over 6 years ago
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.
Updated by krileon over 6 years ago
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.
Updated by krileon over 6 years ago
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).
Updated by krileon over 6 years ago
- 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.