Creating a New date field using if statement

[#1]

Hi

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
1	Created	01/01/2017	01/01/1950	01/01/2017
2	Created	02/01/2017	01/01/1950	02/01/2017
3	Cancelled	02/01/2017	01/01/1950	02/01/2017
4	PIS	03/01/2017	16/01/2017	16/01/2017
5	PIS	03/01/2017	19/01/2017	19/01/2017

Any ideas would be apreciated

[antoniotiman]

Hi Taahir

LOAD *,

If(Status='PIS',[Date PIS],[Date Created]) as [Combined Date]

From Table;

Regards,

Antonio

[#3]

Worked like a bomb, thanks Antonio