Forum Discussion
_anomDiebolt_
7 years agoQrew Elite
I think this is what you are looking for:
If([Start Date/Time] < Now() and Now() < [End Date/Time],However, you statements "I have a column called Tours. When I click on Tours" and "two properties of the tour field" leave me a little confused as you refer to Tours as if it wasa field when I think you might mean Tours is a table.
"Yes",
"No"
)
JohnBarulich1
7 years agoQrew Cadet
Update of the current situation:
So I decided to add an 'Available' field in my 'Tours' table that is populated based on Start and End time, which was successful. Thanks for the code snippet. (Although it would still be nice to know how to reference a field from another table)
However, I still want to populate the 'Available' field in my 'Tractors' table. Both of these tables have a 'Unit #' field, which would probably be the best way to retrieve if it is available or not.
The objective would be to get the Unit # from this 'Tractors' table, find the corresponding Unit # from the 'Tours' table, and populate the 'Available' field in 'Tractors' table to the same availability state in the 'Tours' tab.
Would this be the best route to take?
So:
1. Get Unit # from 'Tractors' table
2. Find Unit # in 'Tours' table
3. Get 'Available' from 'Tours' table
4. Set 'Available' in 'Tractors'
Thanks for any help.
John
So I decided to add an 'Available' field in my 'Tours' table that is populated based on Start and End time, which was successful. Thanks for the code snippet. (Although it would still be nice to know how to reference a field from another table)
However, I still want to populate the 'Available' field in my 'Tractors' table. Both of these tables have a 'Unit #' field, which would probably be the best way to retrieve if it is available or not.
The objective would be to get the Unit # from this 'Tractors' table, find the corresponding Unit # from the 'Tours' table, and populate the 'Available' field in 'Tractors' table to the same availability state in the 'Tours' tab.
Would this be the best route to take?
So:
1. Get Unit # from 'Tractors' table
2. Find Unit # in 'Tours' table
3. Get 'Available' from 'Tours' table
4. Set 'Available' in 'Tractors'
Thanks for any help.
John