query with speciific dates

[Pasi]

and sql view : dbo_location_mstr1.alt_phone_ext, dbo_appointments1.appt_kept_ind
HAVING (((dbo_appointments1.appt_date) Between "20131201" And "20131208") ----. I change it back to the original date.

Hope this helps??
Thanks.

[pbaldy]

If that works, the data type of appt_date has to be text, not date/time. You'd get a data type mismatch otherwise.

[Pasi]

So How do I set it as text? below is the sql view

here is in sql view:

dbo_location_mstr1.alt_phone_ext, dbo_appointments1.appt_kept_ind
HAVING (((dbo_appointments1.appt_date) Between Date()-"7" And Date())

[Pasi]

And I do get mistmach error whats the best way to d o this so I can set it automatically to retrieve the last 7 days?
.Thanks.

[Pasi]

I tried this but not working: DateAdd("d",-7,("date()",ConvertText("varchar",Date(),101)))

[pbaldy]

Try something like

Between Format(Date()-7,"yyyymmdd") And Format(Date(),"yyyymmdd")

[Pasi]

YES!!!!!!!!!!!!!!!!!!!!!!!!!!! that did it ...!!!!!! YOU ROCK!!!!!! Paul! Thanks so much!!!!!!!!!! I owe you one!

[Pasi]

Paul One more thing,, should I set the -7 to -6 since it includes the todays date?

Thanks!!!

[pbaldy]

Happy to help! You can certainly change the days to be subtracted to meet your needs.

[Pasi]

Thank you! you Rock!!!