I am using the default setting for a date/time, e.g. no modifications just using what PHPMaker defaults to. I am using the default datepicker extension as well. I have a client that chose a date far in the future for an expiration of a news item 2050-01-01 and it’s showing up properly in the UI (see screenshot) but when submitted it it being entered as 1950-01-01 (second screenshot) thus causing it to not be shown.
how can I fix it so that the proper date is used
If you use year like 50, some databases may think it is 1950, other databases may think it is 2050. You may try to change the date/time format of the field to MMddy and try again.
this is mysql so our format is yyyy-mm-dd hh:mm:ss. I tried changing the datatype to DATE same issue. I do feel this is an issue with the date time picker plugin
I meant changing the date/time format under View Tag panel in your project, not changing the date format or type of the field in the database.
