I am trying to use the QUERYDATE function. I am querying a TB WIP database.
I am using:
{TransDate}<=QUERYDATE("Enter starting date",01-01-05)
A calendar pops up starting 1900. Obviously I don't want to scroll through 105 years to choose my beginning date!
Currently I want to look at transactions from Jan 1, 2005 to Dec 31, 2005 but it would be nice to set something up so that I could look at any range of dates.
Please help.
Thanks.