Query Help --- Retrive last 45 days back record anytime.

[sd110404]

Hi All,

I need help on this query. Any help will be appreciated.

I have a date field (mm/dd/yyyy format) in Customer table.

I need to retrieve 15 days back customer names

Select customername frm customer where joindate between.....

The query must return All the customer whose joindate is within the last 15 days.

Thanks in advance.

 

[PHV]

Select customername frm customer where joindate between Date()-15 And Date()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sd110404]

Thanks a Ton PHV it worked.