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)
Solved! Go to Solution.
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]),
)
)
)
Try as the Valid If expression:
OR(
([_THIS] < [agenda]),
([_THIS] > [Previsรฃo de Tรฉrmino])
)
I thought of the expression:
IF (
[_ THISROW]. [MONTADOR] = [MONTADOR],
(OR( ([_THIS] < [agenda]), ([THIS] > [Previsรฃo de Tรฉrmino]))), [ THIS]
)
But in the expression valid IF is not accepted
Does not work.
It is giving error when I put any value in [agenda].
I did not mention that the value of the [agenda] column varies according to the technical column (Montador).
Please provide a screenshot of the error.
Please provide a screenshot of the error.
ANY VALUE SHOWS THIS MESSAGE
What comes close to what I want is:
in the Valid IF expression:
NOT(
IN ([_ this],
select(
geral[AGENDA], AND([_ thisrow].[MONTADOR] = [MONTADOR]
)
)
)
)
But this expression blocks only identical entries from [AGENDA] already registered.
I want to block all entries between [AGENDA] and [PREVISรO DE TรRMINO]
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]),
)
)
)
I was about to say it didnโt work, but I removed that last comma and it worked.
thank you
Whoops! My mistake, and good catch on your part! Iโm glad it worked for you!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |