Community
Showing results for 
Search instead for 
Do you mean 
Reply

Changing Character fields to Date Fields

New Member
Posts: 5
Country: United States

Changing Character fields to Date Fields

We set up our database fields incorrectly. We need to change a character field (that now contains dates in xx/xx/xxxx format) to a proper date field.  What will happen to our data?  Currently as a character field we can not search date ranges.

Thanks

Moderator
Posts: 4,395
Country: USA

Re: Changing Character fields to Date Fields

It should convert without any issue if all the dates are in proper format.  Instead of changing the field type, I would create a new date field and then copy the dates to the new field by going to Edit > Copy Field.
New Member
Posts: 5
Country: United States

Re: Changing Character fields to Date Fields

Yes that worked.  Thank you