Text Field to Date Field
Is there a way to convert data in a text field to date? I have a text field with the data 2009-10, which should read October 2009. How can I convert this data to a date field (Oct 2009)? Thanks.
This calcuation will work:
Let ( Hyphen = Position ( Name ; "-" ; 1 ; 1 ) ; Date ( Right ( Name ; Length (Name ) - Hyphen ) ; 1 ; Left ( Name ; Hyphen - 1 ) ) )
This changes 2009-10 to the date 10/1/2009 (MMDDYYYY)
You can then format the field to display only the three letter month abbreviation and the 4 digit year when you place it on a layout.
Thank you, Mr. Caulkins. It works beautifully.
Retrieving data ...