OnDemand User Group
Support Forums => MP Server => Topic started by: apaes on March 24, 2022, 07:22:31 AM
-
Hello everyone. Good day.
I am trying to change data type for a field on the group application. This field is an index. I want to change from "data" data type to "Data (old style)" data type but even logged in as an Admin he can't do that. Any idea how to perform that change ? This is the error I am seeing on th log:
Erro -200: '10/05/20' is invalid for 'Time Stamp'. A date/time in the range '' to '9999-12-31' is required. Note that 2-digit years less than 70 are interpreted as year 20nn.
Any clue on how to do that change ?
Regards,
Andre
-
It looks like the problem is that you have defined the field as a 'Date and Time' field, when you really just wanted a 'date' field.
You can fix this by copying the App Group definition and making the change from date/time field to a date field before you save it. Once you set a field type, you can't change it.
Alternately, make sure the index data that you're trying to load contains date *and* time information - even if it's just zeros.
And of course, make sure that inside your Application Definition, you're using the right date field format - %m/%d/%y, etc.
Good luck!
-JD.
-
Thanks Justin! Appreciate your help! I will follow your guidance on this. Regards, André