C
Chuck W
Hello,
I extract data out of a system to a text file that gives me several fields
including a field called MonthCode. The values in this field are all six
digits (200812, 200901). I then import this into access and then change
the format to a number field with no problem. I need to change this to a
date field (12/1/2008, 1/1/2009). When I attempt to simply change it to a
date field I get the data value of 10/19/2449 for 200812. What is the best
way to make this change? I will have to do this often so I would like to
either automate it or write a write where the value appears automatically.
Thanks,
I extract data out of a system to a text file that gives me several fields
including a field called MonthCode. The values in this field are all six
digits (200812, 200901). I then import this into access and then change
the format to a number field with no problem. I need to change this to a
date field (12/1/2008, 1/1/2009). When I attempt to simply change it to a
date field I get the data value of 10/19/2449 for 200812. What is the best
way to make this change? I will have to do this often so I would like to
either automate it or write a write where the value appears automatically.
Thanks,