can anyone tell me why this is coming as an invali...
# suiteflowp
pen one
07/05/2022, 5:07 PMcan anyone tell me why this is coming as an invalid expression:
DECODE((to_char({datecreated}, 'MM'), '01' , 1))k
KevinJ of Kansas
07/05/2022, 5:19 PMI think you've too many parenthesis
KevinJ of Kansas
07/05/2022, 5:19 PMlast one should be able to be deleted
j
jen
07/05/2022, 5:59 PMthere are three left brackets and three right brackets…?
jen
07/05/2022, 5:59 PMbut yes, remove one from both sides
jen
07/05/2022, 6:00 PMsidenote: am I the only one that checks brackets from left to right by counting / adding / subtracting? Like going “1…2…….3…..2…..3…..2….1….2…..3…..2…..1……….0”
jen
07/05/2022, 6:00 PMand making sure I end w/zero
k
KevinJ of Kansas
07/05/2022, 6:06 PMAlso your to char might actually just be an integer.
KevinJ of Kansas
07/05/2022, 6:06 PMso you might also compare it to
01'01'KevinJ of Kansas
07/05/2022, 6:06 PMthough, in this case, I'd kind of wonder why you are doing it the way you are.
KevinJ of Kansas
07/05/2022, 6:08 PMalso - if you are doing this in a workflow - then you may be running into an instance where you need to use client script instead of SQL
KevinJ of Kansas
07/05/2022, 6:08 PMWhat is the context in which you are doing this?
p
pen one
07/05/2022, 8:31 PMgoal is to show total transactions created for each month
k
KevinJ of Kansas
07/05/2022, 11:00 PMSo this isn't in a workflow?
KevinJ of Kansas
07/05/2022, 11:00 PMAlso - can't you just use date created?
KevinJ of Kansas
07/05/2022, 11:00 PMAnd put the month modifier on it?
KevinJ of Kansas
07/05/2022, 11:01 PMmessage has been deleted
4 Views