RE: Formula assistance for custom transaction field.
Hello,
Our production process is tied to two dates on our sales order. A Build Date (When a car goes into production) and a Target Date (when it should be delivered to the customer).
Due to supply shortages, we would to keep the two dates for our production team as is but create a custom field that will give a “Delivery Window ” that would be presented to the customer, based on the Target Date.
The requirement is to have the Delivery Window Show
- If the Target date is within the 1st -15th of the month The window would be 1-15 (month of the Target Date) 1-15 May
- If the Target date is within the 16th -31st of the month The window would be 16 -31 (month of the Target Date) 16-31 Aug
Any assistance is greatly appreciated.
Thank you
Brent
Then they wanted three windows. First of, Mid of and End of. So we went with:
case when EXTRACT(DAY FROM {custbody_target_delivery_date}) > 20 then concat(‘End of’||’ ‘, To_Char({custbody_target_delivery_date},’MONTH’))
when EXTRACT(DAY FROM {custbody_target_delivery_date}) < 10 then concat(‘Beginning of’||’ ‘, To_Char({custbody_target_delivery_date},’MONTH’))
else concat(‘Middle of’||’ ‘, To_Char({custbody_target_delivery_date},’MONTH’)) end
