INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: drosoph on December 06, 2007, 10:11:34 pm

Title: Can I convert 01, 02, 03 ... to January, February, March?
Post by: drosoph on December 06, 2007, 10:11:34 pm

I have a bunch of files that have all of the dates parsed in fields that are listed as 01, 02, 03 ... and I need to convert that to January, February, March, etc .... Any way to do this in a custom expression?

Title: Re: Can I convert 01, 02, 03 ... to January, February, March?
Post by: Matt on December 06, 2007, 10:41:35 pm

Well, you could do one month at a time by picking all the files and editing them like:
=If(IsEqual([My Field], 1, 2), January, [My Field])

Then do the next month:
=If(IsEqual([My Field], 2, 2), February, [My Field])

etc...