Search Criteria

[JennKriv]

I am wanting to do a search that will show me records within a specific time
frame. I have it set up now to enter a Pay Period Start Date and End date but
I want to be able to get the results without entering so much info. I want to
be able to put in the start date and then have it automatically grad the
records for the 14 consecutive days but I can't figure out the syntax.
Also I currently have to enter the date 27/04/08 I keep forgetting the / so
is there a way to code it so that all I have to enter is the number ie:270408
?

 

[KARL DEWEY]

I would recommend that EndingDate be like this --
EndingDate: DateAdd("d", 14, DateSerial(Left([Start
date],2),Mid([Startdate],2), Right([Start date],2)))


--
KARL DEWEY
Build a little - Test a little

I am wanting to do a search that will show me records within a specific time
frame. I have it set up now to enter a Pay Period Start Date and End date but
I want to be able to get the results without entering so much info. I want to
be able to put in the start date and then have it automatically grad the
records for the 14 consecutive days but I can't figure out the syntax.
Also I currently have to enter the date 27/04/08 I keep forgetting the / so
is there a way to code it so that all I have to enter is the number ie:270408
?

How do you have it setup to do that?

Without knowing that, I can offer a couple of expressions as
hints:

StartingDate: DateSerial(Left([Start date],2),Mid([Start
date],2),Right([Start date],2))

EndingDate: DateAdd("d", 14, StartingDate)