Creating a New date field using if statement

Fri, 25 Aug 2017 07:07:29 GMT

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

Re: Creating a New date field using if statement

antoniotiman — Fri, 25 Aug 2017 07:13:44 GMT

Hi Taahir

LOAD *,

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

From Table;

Regards,

Antonio

Fri, 25 Aug 2017 08:49:59 GMT

Worked like a bomb, thanks Antonio