Forum Discussion

Petter120's avatar
Petter120
Helper I
6 years ago
Solved

If time value is between two other time values

Hi i have a column that has a time value for example 10:05:22 (hh:nn:ss).    I am trying to figure out how to use an if statement that tests if the time value is between 10:00:00 and 10:59:59 but i...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Petter120

    If Table[Column1] is what you want to check:

    Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)

AlB's avatar
AlB
Community Champion
6 years ago

Hi Petter120

If Table[Column1] is what you want to check:

Table1[Column1] > TIME(10,00,00) && Table1[Column1] <= TIME(10,59,59)

  • Petter120's avatar
    Petter120
    Helper I
    6 years ago

    AlB Thank you so simple 🙂