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?
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.