Yes, thank you. I already store the companies fiscal year date in their table as a date, for example 1/1/08 as 'Fiscal_Year_Begins'.

I was assuming that if I know when...

Thanks for the reply. My date field is formated as "Datetime", and when I try to just type '20080205' into the date field, it gives an error.

When...

How do I truncate the time part in the datetime column? I think that's what I need to do thanks!

Also, how would I specify the previous day? This...

I figured it out, thanks again!

awesome! Thank you. But how do I format this so that I can use it as part of a regular query and use a column name as @myfile?

Thanks again!