This content has been marked as final. Show 2 replies
I need some assistance regarding a problem i am facing.
i currently have two date fields and need to combine them to form a single date field based on the status of the item.
if the item is PIS it should take the PIS date, if the item is anything else but PIS it should take the date created date.
|Order ID||Status||Date created||Date PIS||Combined Date - Desired|
Any ideas would be apreciated