Gotcha! Now, you don't have to worry. So, there is no need to create a new field.
Just modify the code of your [Due in Opentext] field.
var date toMRC = WeekdayAdd([To MRC], 5);
var text day = Case(DayOfWeek($toMRC),
0,"Sunday", 1,"Monday", 2,"Tuesday", 3,"Wednesday", 4,"Thursday", 5,"Friday", 6,"Saturday"); var text month = Case(Month($toMRC),
1,"Jan", 2,"Feb", 3,"Mar", 4,"Apr", 5,"May", 6,"Jun", 7,"Jul", 8,"Aug", 9,"Sep", 10,"Oct", 11,"Nov", 12,"Dec");
var text dueInOpentext = $day &","&" "& $month &" "& Day($toMRC);
If([Shot Type]="Standard","See lifestyle", $dueInOpentext)
Try this formula into your [Due in Opentext] field. Please let me know if this works for you.
Thanks,
Gaurav