Showing results for 
Search instead for 
Do you mean 

changing the data type of a field

New Member
Posts: 7
Country: USA

changing the data type of a field

I defined a new field and chose date as the field type.  For whatever reason when I went back into Act! it was set up as characters.  I went back to the define field to edit it but the drop down is now limited and the date option does not appear.  Without having to create another field and start from scratch, how can I change that field?
Platinum Elite Contributor
Posts: 6,860
Country: USA

Re: changing the data type of a field

The Date data type can be specified only at the time the field is created. I don't have an explanation for why it ended up a character field, my guess was it happened inadvertently (if I had a dollar for every fat-finger goof I've made, I could retire). You will need to delete the field and recreate it with the correct data type.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer