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

)

  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    If(
      [Period Tested] = Date(2016, 1, 1), 1,
      [Period Tested] = Date(2016, 2, 1), 4
    )

    Date(2000, 1, 10) returns the date January 10, 2000
  • 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.
  • SammySSammyS's avatar
    SammySSammyS
    Qrew Cadet
    7 years ago
    Thanks Chris and Dan, the ToDate() function worked fine in this scenario!