When we had some attributes created 2 of our date fields were created using Text rather than DateTime
I have been through some articles mentioning using CDATE, however I have not been able to get this to work yet. The final aim is to be able to sort by Contract End date DESC in the Customers GI.
Is there a way to do this without recreated the fields?
Is there a way to do this without recreated the fields?
Yes and no.
You should be able to convert a correctly formatted string to a date with CDate(), but since you have no validation on your field, anyone could enter anything, therefore probably giving you errors when attempting to convert.
You could create new date attributes and attempt to copy the values from the current string attributes to the new date attributes, but this is magnificently complex.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.