Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having trouble with this if statement in the load editor.
Here is an excerpt from my script:
[_Onesheet_churn]: LOAD monthname("Original Order Date") as [original_order_date] FROM onesheet_churn [_Add_Order_date_churn]: Load monthname(if((original_order_date)<monthname('2011/4/18'), monthname(makedate(2011,4,18)), original_order_date)) as [churn_order_date] Resident _Onesheet_churn |
The result is that my dates prior to "2011/4/18" are not converted to "2011/4/18," the dates are showing up in their original form.
What I need is "if(original_order_date)<(2011/4/18) then change the date to (2011/4/18) , else [original_order_date] as [churn_order_date]
Any help is much appreciated!
Maybe something like
monthname( RangeMax( original_order_date, Makedate(2011,4,18) ) ) as [churn_order_date]
Maybe something like
monthname( RangeMax( original_order_date, Makedate(2011,4,18) ) ) as [churn_order_date]
Or
[_Onesheet_churn]:
LOAD
monthname("Original Order Date") as [original_order_date]
FROM onesheet_churn
[_Add_Order_date_churn]:
Load
monthname(if((Num(original_order_date))<Num(monthname('2011/4/18')), monthname(makedate(2011,4,18)), original_order_date)) as [churn_order_date]
Resident _Onesheet_churn
this did the trick thank you!