Converting Date Fields in Character Format to Date Format

1 post / 0 new
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Converting Date Fields in Character Format to Date Format
Hello Group Members,
 
Date fields in an IDEA database may appear within IDEA post import in Character format. This precludes Date based analytics since the field is in a Character format.
 
There are two ways we can convert the Date field in a Character format to a Date format.
 
One - Modify the existing field ~ change the field type from Character to Date and enter a suitable mask to mimic the Date. For example 30-JAN-19 is to be masked as DD-MMM-YY
 
Two - Append a new field ~ append a virtual date field with the criteria @ctod(Field Name, "DD-MMM-YY") in case the dates are appearing as 30-JAN-19. 
 
Once the field is appearing in a date format the much required Date based analytics can be done like Aging and more.
 
Best Regards
 
Group Admin Team