dates of lost 5 days

[infovasuinfo]

hello all,

for my application i have to take dates those stored in datebase of lost 5 days.

i tried for that like this

select LExpiryDate from vehiclesdetails where LExpiryDate>(Date()-5) and LExpiryDate<Date()

but it is not coming

if anybody knows please tell me

thanks in advance

regards
vasu

[kleky]

Firstly I'd ensure that the apparent date field is actually a Date type (see the design).

Secondly, use the DateAdd function...

DateAdd("d","add to",value(+/-))

[Satej Datar]

i assume you want data of previous 5 days

try this if running query in access:
select LExpiryDate from vehiclesdetails where
LExpiryDate > #(Dateadd("d", -5 ,date ) #
and LExpiryDate< #date #