Forum Discussion

JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago

Wondering how to reference a property from a field in the same table

Hi people, I have just started using QuickBase but having coding experience. In my table, I have a column called Tours. When I click on Tours, it shows me Start Date/Time and End Date/Time. In the ...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
I think this is what you are looking for:
If([Start Date/Time] < Now() and Now() < [End Date/Time],
  "Yes",
  "No"
)
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.
JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago
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