Topic: cdate function Posted: 03 Sep 2007 at 12:51am
Hi all,
I am trying to convert a string field to a date field.
The string field at the minute in the format: JUL-06, AUG-06, DEC-06, JUN-07, AUG-07, ... ...
This monthly period is the basi sof my grouping, but when I sort the groups it obviously sorts them in alphabetical order because it is a string field.
I need to sort them in date order. I dont really want so do it manually using specified order because there will be new periods added constantly.
Will this cdate function work to convert this string?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 04 Sep 2007 at 4:10pm
Because your field is not a complete date, I doubt it will work. You'll have to either reformat the string into a format like "JUL 1, 2006" or break it down into numbers and use the Date function, something like this:
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
