Hello
I am querying off of multiple tables and I would like to create/save a query in which one of the criterion is that a date value in a column is from 3 days ago or earlier. Here is the fun part: The date values in that column are actually not formatted as a date. An example for today's date would be 20040210. Does this have to be converted or something? If so, after it's converted.....can the filter be executed with a function (similar to Excel) like "TODAY()-3", or does this have to be done with VB code? Either way I am lost with this one. Can somebody help me out with this?
Thanks,
Nick
I am querying off of multiple tables and I would like to create/save a query in which one of the criterion is that a date value in a column is from 3 days ago or earlier. Here is the fun part: The date values in that column are actually not formatted as a date. An example for today's date would be 20040210. Does this have to be converted or something? If so, after it's converted.....can the filter be executed with a function (similar to Excel) like "TODAY()-3", or does this have to be done with VB code? Either way I am lost with this one. Can somebody help me out with this?
Thanks,
Nick