I have imported a pipe delimited .txt file into a database. One of the fields is 'Year_Month' and its data comes in as text in format 'yyyymm' as in '201412'.
I now update the database with another .txt file that has corresponding date field as '201501'. I save the value of the first record's date field as rcdDate.
When I do a Msgbox Dmax on the 'Year_Month' field, I get '6/11/2451', which is the date value of '201412', which I don't understand.
Also, I'm trying to update only records that have been added. I'm using a query that uses a 'Where [Year_Month] = 'rcdDate', but it's not working. Please help.
Thanks.
I now update the database with another .txt file that has corresponding date field as '201501'. I save the value of the first record's date field as rcdDate.
When I do a Msgbox Dmax on the 'Year_Month' field, I get '6/11/2451', which is the date value of '201412', which I don't understand.
Also, I'm trying to update only records that have been added. I'm using a query that uses a 'Where [Year_Month] = 'rcdDate', but it's not working. Please help.
Thanks.
[SOLVED] Need help with text field comparison
0 commentaires:
Enregistrer un commentaire