INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Can I convert 01, 02, 03 ... to January, February, March?  (Read 701 times)

drosoph

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 661
  • TiVo-aholic
Can I convert 01, 02, 03 ... to January, February, March?
« 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?

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42002
  • Shoes gone again!
Re: Can I convert 01, 02, 03 ... to January, February, March?
« Reply #1 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...
Logged
Matt Ashland, JRiver Media Center
Pages: [1]   Go Up