is this formula in a proper format? nvl({custentit...
# suiteqlt
Tash
12/13/2022, 3:33 PMis this formula in a proper format? nvl({custentity_cdi_ar_last_task_date},'12/31/1999') i get the following error message
Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.
Search: Customer Search
Formula: nvl({custentity_cdi_ar_last_task_date},'12/31/1999')
t
Th3VanMan
12/13/2022, 4:00 PM@Tash I gave this a try and it worked. NVL({dateclosed},TO_DATE('12/31/1999','MM/DD/YYYY'))
Th3VanMan
12/13/2022, 4:01 PMthat was in a formula(date) where the formula is not empty
t
Tash
12/13/2022, 4:03 PMThank you!
Tash
12/14/2022, 3:39 PMHey Van
Tash
12/14/2022, 3:39 PMI have a similar question to yesterday and was hoping if you can assist
t
Th3VanMan
12/14/2022, 3:39 PMgo for it
t
Tash
12/14/2022, 3:40 PMreally appreciate the speedy answere
Tash
12/14/2022, 3:40 PMCASE
WHEN TO_DATE(TO_CHAR({trandate}, 'YYYY'), 'YYYY') LIKE '%2021%' THEN {totalamount}
ELSE 0
END
Tash
12/14/2022, 3:40 PMinstead of year im trying to apply this for date range of 1/1/22 - 9/1/22
Tash
12/14/2022, 3:40 PMsorry 1/1/22*
t
Th3VanMan
12/14/2022, 3:41 PMwhat are you getting back? an error?
t
Tash
12/14/2022, 3:42 PMno but im trying to create a formula for each month
t
Th3VanMan
12/14/2022, 3:43 PMone sec, I may have something that may help....but it uses accountperiods to put sales into monthly buckets
t
Tash
12/14/2022, 3:47 PMthank you
Tash
12/14/2022, 3:47 PMthis is what i got CASE WHEN TO_DATE(TO_CHAR({trandate}, 'dd-mm-yyyy'), 'dd-mm-yyyy') LIKE '%01/01/2022%' THEN {totalamount} ELSE 0 END
t
Th3VanMan
12/14/2022, 3:50 PMI'll DM you
3 Views