At first, sorry about my rusty english, than, lets go:
I need check if a DATE was the same of a DUE DATE, than return โAVISOโ (NOTICE), to start a BOT.
The BOT thing I thinkโs ok, my trouble are with a return of DATE = DUE DATE.
So, I try this, on a virtual column I call CHECAR_VENCIMENTO (DUEDATE_CHECK)
first try:
SWITCH(
TODAY() + 3,
[PARCELA_01] , โAVISOโ ,
[PARCELA_02] , โAVISOโ ,
[PARCELA_03] , โAVISOโ ,
[PARCELA_04] , โAVISOโ ,
[PARCELA_05] , โAVISOโ ,
[PARCELA_06] , โAVISOโ ,
[PARCELA_07] , โAVISOโ ,
[PARCELA_08] , โAVISOโ ,
[PARCELA_09] , โAVISOโ ,
[PARCELA_10] , โAVISOโ ,
[PARCELA_11] , โAVISOโ ,
[PARCELA_12] , โAVISOโ ,
โOKโ
)
When I fill the field, its ok, return to me the write value. But after send to DB and back to app, the field change to โAVISOโ (NOTICE), even if it doesnโt meet the requirement.
So, my BOT donโt work, because receive a incorrect return.
Second try, same issue:
IFS(
(TODAY() +3 = [PARCELA_01]), โAVISOโ,
(TODAY() +3 = [PARCELA_02]), โAVISOโ,
(TODAY() +3 = [PARCELA_03]), โAVISOโ,
(TODAY() +3 = [PARCELA_04]), โAVISOโ,
(TODAY() +3 = [PARCELA_05]), โAVISOโ,
(TODAY() +3 = [PARCELA_06]), โAVISOโ,
(TODAY() +3 = [PARCELA_07]), โAVISOโ,
(TODAY() +3 = [PARCELA_08]), โAVISOโ,
(TODAY() +3 = [PARCELA_09]), โAVISOโ,
(TODAY() +3 = [PARCELA_10]), โAVISOโ,
(TODAY() +3 = [PARCELA_11]), โAVISOโ,
(TODAY() +3 = [PARCELA_12]), โAVISOโ,
TRUE, โOKโ,
)
Anyone can help me whith this trouble?
ps.: PARCELA_XX means DUEDATE, AVISO is NOTICE
ps2.: Sorry if is too long and in wrong place ๐
What column type are you using for the [PARECELA_XX] columns? Date? DateTime? Other?
And I assume your [PARCELA_xx] columns are dates in the future?
If the [PARCELA_XX] are defined as DATE data type then the expression should be good. If not, you can correct the expression using a DATE() function like so:
IFS(
(TODAY() +3 = DATE([PARCELA_01])), โAVISOโ,
(TODAY() +3 = DATE([PARCELA_02])), โAVISOโ,
(TODAY() +3 = DATE([PARCELA_03])), โAVISOโ,
(TODAY() +3 = DATE([PARCELA_04])), โAVISOโ,
...
TRUE, โOKโ,
)
I tryed, but not yet.
Same issue, showed the right return when I added, but after go and back do server, returned the wrong value =(
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |