what would be the criteria to see all sales made o...
# administrationt
Tash
05/16/2023, 8:25 PMwhat would be the criteria to see all sales made on sundays within last year? we are deciding if its worth keeping our showroom open on sundays.
m
MGBC
05/16/2023, 8:28 PMUse a formula text in your criteria
TO_CHAR({trandate}, ‘Day’) contains Sunday
t
Tash
05/16/2023, 8:36 PMmuch appreciated
Tash
05/16/2023, 8:37 PMif possible would you mind telling me what's wrong with this formula? i keep getting an error
Tash
05/16/2023, 8:37 PMCASE WHEN TO_DATE(NVL({custbody_cdi_asr_delay_process},TO_DATE('8/28/1998'))) < {today} THEN 1 ELSE 0 END
m
MGBC
05/16/2023, 8:39 PMWhat is your formula type
t
Tash
05/16/2023, 8:40 PMformula numeric should it be date?
m
MGBC
05/16/2023, 8:40 PMTry using decode instead of NVL
🙌 1
MGBC
05/16/2023, 8:43 PMTO_DATE(DECODE({custbody_cdi_asr_delay_process}, NULL, ‘8/28/1998’, {custbody_cdi_asr_delay_process})) < {today}
MGBC
05/16/2023, 8:43 PMAlso what is your field type of your delay process field
t
Tash
05/16/2023, 8:52 PMThank you i got it to work!
m
MGBC
05/16/2023, 9:00 PMNo problem. Always happy to help