Add Days only for selected data

[andyrebs]

Hello,

I have a table as below:

Description	Type	Expire Date
Description1	SC	12-05-2012
Description2	SC	12-05-2012
Description3	SF	12-05-2012
Description4	SS	12-05-2012
Description5	SC	12-05-2012
Description6	SF	12-05-2012

I would add in the script 14 days on the Expire date only on the records that have value SS. It is possible?

Thank you

[swuehl · Accepted solution]

Maybe like

LOAD

Description,

Type,

if(Type = 'SS', date([Expire Date]+14),date([Expire Date]) ) as [Expire Date],

...

from Table;

Your Expire Date must be read in as date type (adjust your standard date format if needed).

hope this helps,

Stefan