Converting Text to Dates

[#1]

I have a list of text.

Ex.

Month 1

Month 2

Month 3

Month 4 etc...

Where month 1 is the current month, month 2 is the previous month, month 3 is the month before that and so on.

I need to convert them so that the current month returns the first day of this month (6/1/2013, the previous month, the month before that, etc all as the first day of their corresponding months).

Month 1     06/01/2013

Month 2     05/01/2013

Month 3     04/01/2013

Month 4     03/01/2013

Any ideas would be fantastic as I am completely stuck.

Thanks!

[swuehl · Accepted solution]

Try something like

LOAD Month,

     Date(Monthstart(today(),1-subfield(Month,' ',2))) as MonthDate;

LOAD * INLINE [

Month

Month 1

Month 2

Month 3

Month 4

];

[#3]

AWESOME!!