date range finds...

[richshone]

posted April 28, 2001 07:22 PM

[Moon]

I am not sure what your question is, but I can answer one issue you present, which is the temporarily empty end date. I woud use a calculated field for the end date which uses the start date in the absence of a date entered into an manually entered end date field. For example

StartDate> Date Field

EndDate> Date Field

EndDateCalc> Calculated Field with Date Result:

If ( IsEmpty(EndDate), StartDate, EndDate)

At least you have a date range to work with. Not sure this answers your query though.

[ May 02, 2001: Message edited by: Moon Mullins ]

[ May 02, 2001: Message edited by: Moon Mullins ]