Date searches???

[anita hamis]

Hi all

i have this database that shows records that have been input in different days. say mon,tue etc.

i have several buttons that take a user to records based on the date.

i have succeded in showing todays records(using the insert calculated result(current date) to perform a search and give out the records.

One snag though, when it comes to showing records for a particular range of dates ..the thing just fails it only shows records for one date and not all the records that are within the range.

is there a way of modifying this:

(Day(Status(CurrentDate)-3) & "/" & Month(Status(CurrentDate)-3) & "/" & Year(Status(CurrentDate)-3)

so that i can get all the records that fall within this range?

thanks

anita

[danjacoby]

Your calc only shows one date, not a range. That's why it's returning one date.

You need to define two dates, a beginning date and an end date, and separate them with the range symbol (...).

HTH,

Dan

[anita hamis]

Thanks for the reply.

i have done that..put the range symbol(in between the starting date and ending date) but there is an error message saying that this(...) cannot be evaluated.

i wonder what that means??

anita.

[anita hamis]

This is very strange.

I have tried all the methods i know but an arror message still comes.

How come this range symbol cannot be evaluated?

its like this:-

Day(Status(CurrentDate)-3)..Day (Status ( CurrentDate )) & "/" & Month(Status(CurrentDate)-3)..Month (Status ( CurrentDate )) & "/" & Year(Status(CurrentDate) -3)..Year (Status ( CurrentDate ))

This should give me the dates from the day before yesterday untill today.

Thanks

anita

thanks

anita

[ZuperZZ]

Anita,

To get a range of dates try this:

1. Create two Global fields, Initial_Date and End_Date

2.In the script:

Enter Find Mode []

Set field ["Date","Initial_Date"]

Insert Text ["Date","..."]

Insert Calculated ["Date","End_Date"]

Perform Find []

ZZ

PD.

* Instead of (Day(Status(CurrentDate)-3) & "/" & Month(Status(CurrentDate)-3) & "/" & Year(Status(CurrentDate)-3) use the "Today" function.

[anita hamis]

Thanks a lot that worked perfect!

i only had to use the date to text function instead of insert text.

anita