Thank you. I tried this but I'm getting date to come out in same format (example) 060812 is coming out as 06/08/12. What I'm looking for is to get it to come out like this: 120608. (so that i can sort it by year, month, day)
Thank you Hilfy. I am able to use the function to separate out month, day and year into 3 separate fields, but how would I get it to make one field? example: I want the original string 060812 to come out like this: 120608 so that it is sortable by year first, then month, then day.
or use Sastry's suggestion to covert it to a date type and then use the format options on that formaul field to dispaly as desired (right click and select Format field and use the date tab to manage the display string)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
