URL with Field equal to another Field

[Jason Barker]

I have this date field (start date) that is set to a Monday within two weeks of the creation date of the record. I also have a date calculation field that runs through the same algorithm based on today's date (currrent start date). I'm trying to do a FIND through a URL where the start date equals the current start date. I'm not having any luck by using the field names in my query (i.e. &start_date=current_start_date) as I think it's looking for a start_date with a value of "current_start_date". How can I accomplish this? Can this even be done in FM?

Thanks in advance!

Jason

Edited February 27, 2006 by Guest

[Martin Brändle]

If this fields are in the same record, then create a calculation field compare_date that compares the two fields: start_date = current_start_date

Then do a search for &compare_date=1