Priya,
The type 'datetime' editable region expects the date inputted (via code) within it to be in 'Y-m-d' format (e.g. 2019-02-01) and hence the error.
You need to first convert the date from CSV to the required format before trying to input it in the region.
For example, assuming the CSV date is named '_csv_date', if currently you are using this -
You need to do the following instead -
Hope this helps.
The type 'datetime' editable region expects the date inputted (via code) within it to be in 'Y-m-d' format (e.g. 2019-02-01) and hence the error.
You need to first convert the date from CSV to the required format before trying to input it in the region.
For example, assuming the CSV date is named '_csv_date', if currently you are using this -
- Code: Select all
<cms:db_persist
att_date = _csv_date
/>
You need to do the following instead -
- Code: Select all
<cms:db_persist
att_date = "<cms:date _csv_date format='Y-m-d' />"
/>
Hope this helps.