Could you be more specific? It's not difficult to convert "January" to 1, "February" to 2, etc., but to make it a date you also need a day and a year - where are these supposed to come from?
Well, I had hoped I might be able to input an instruction "where (text field) reads January in this record, input (date field) 01/01/2010 here. Maybe I'm being overambitious?
Maybe I'm being overambitious?
No, you're being vague. Why 2010, and not 2009 or 1544? Perhaps it would help if you explained the purpose behind this.
If you ALWAYS want day 1 and year 2010, you can use a calculation (result is Date) =
Ceiling ( Position ( "janfebmaraprmayjunjulaugsepoctnovdec" ; Left ( Textfield ; 3 ) ; 1 ; 1 ) / 3 ) ;
I'm dealing with a database full of tasks all planned for next year which is why 2010. People have input a month in 2010 or a Quarter when they expect the activity to take place. I need to convert this info into two fields - StartDate and EndDate, so e.g. if the text field reads January, I'd like the StartDate field to read 01/01/2010 and the EndDate to read 31/01/2010. If I can specify this in a calculation field that would be great, but I'm not sure I can? PS, I'm not a programmer ..
if the text field reads January, I'd like the StartDate field to read 01/01/2010
That's what the above formula will do.
For EndDate, you can use =
Date ( Ceiling ( Position ( "janfebmaraprmayjunjulaugsepoctnovdec" ; Left ( Textfield ; 3 ) ; 1 ; 1 ) / 3 ) + 1 ; 0 ; 2010
Tha solves it! Thank you!