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
Thanks for the quick response!
Sorry for the confusion, I'm learning the semantics still. My table is 'Tractors', and a field of the table is 'Available' and 'Tours'. This 'Tours' field is a relationship to another table called 'Tours' which has a Start Date/Time and End Date/Time.
So I would like to get those Start and End values for a formula in my 'Available' field. So some pseudocode:
'[Tours].StartDateAndTime ..... [Tours].EndDateAndTime'
Thanks again,
John
Sorry for the confusion, I'm learning the semantics still. My table is 'Tractors', and a field of the table is 'Available' and 'Tours'. This 'Tours' field is a relationship to another table called 'Tours' which has a Start Date/Time and End Date/Time.
So I would like to get those Start and End values for a formula in my 'Available' field. So some pseudocode:
'[Tours].StartDateAndTime ..... [Tours].EndDateAndTime'
Thanks again,
John