Forum Discussion

SammySSammyS's avatar
SammySSammyS
Qrew Cadet
7 years ago

Using the equals(=) operator when referencing a date to a number in an IF statement

I am looking to create a numeric formula field in a table.  I am looking to define a specific number based on the date in a field called "Period Tested".  For example: If Period Tested = 01-01-2016...
Errors
Formulas and functions
Tables and fields
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
7 years ago

try

If(

[Period Tested]=ToDate("01-01-2016"),1,
[Period Tested]=ToDate("02-01-2016"),4

)

ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
7 years ago
If [Period Tested] is a Date/Time field, you'll need to use the ToDate() function on [Period tested] too.