08-07-2013, 07:36 AM
That's a reasonable idea, but ideally there should be a rule or mask to ensure the data is saved in the correct way. Otherwise it would make searching for a particular incident by date quite difficult, due to the variable formats that could be used in the free text field.
01/01/2013
01/01/13
1/1/13
1-1-13
01-01-2013
01-Jan-2013
You get the gist.......
01/01/2013
01/01/13
1/1/13
1-1-13
01-01-2013
01-Jan-2013
You get the gist.......