Author Topic: Error changing field data type  (Read 961 times)

apaes

  • Newbie
  • *
  • Posts: 6
    • View Profile
Error changing field data type
« 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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Error changing field data type
« Reply #1 on: March 24, 2022, 12:03:36 PM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

apaes

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Error changing field data type
« Reply #2 on: March 29, 2022, 06:03:56 AM »
Thanks Justin! Appreciate your help! I will follow your guidance on this. Regards, André