Solved: Error if date is between or same than a column - Page 2

Eduardo_dos_San · 04-25-2020 02:28 PM

Hi guys, i have a problem to validate an datetime

i need to only accept and datetime if the value is different than the interval value from column AGENDA and PREVISÃO DE TÉRMINO

Example:
there is a value in a row with agenda = 24/04/2020 10:00 and Previsão de Término = 24/04/2020 20:100
So the new value to agenda must be lower or greater(or diferent) than these interval, like:
24/04/2020 09:59 (09:59 a.m) or 24/04/2020 20:01 (08:01 p.m)

Steve

So the value of agenda in the form is only valid if it does not fall within the time spans between agenda and Previsão de Término of any rows of the geral table that have the same montador column value as that in the form? Try:

ISBLANK(
  FILTER(
    "geral",
    AND(
      ([_THISROW].[montador] = [montador]),
      ([_THISROW].[agenda] >= [agenda]),
      ([_THISROW].[agenda] <= [Previsão de Término]),
    )
  )
)

View solution in original post