Desktop productivity for business analysts and programmers

When a column meets a criteria add 30 days to date field

Reply
New Contributor
Posts: 2

When a column meets a criteria add 30 days to date field

I am trying to add days to a date field if another column meets a criteria of Yes.   I am doing this in enterprise guide.    if the column has Yes than add 30 days to the date field column.     Any suggestions?

 

Respected Advisor
Posts: 2,660

Re: When a column meets a criteria add 30 days to date field

if column='Yes' then date=date+30;
--
Paige Miller
New Contributor
Posts: 2

Re: When a column meets a criteria add 30 days to date field

Posted in reply to PaigeMiller

Thanks for your response.   Been trying different variations of that and it doesn't like it

 

Respected Advisor
Posts: 2,660

Re: When a column meets a criteria add 30 days to date field

Show us the SASLOG. 

--
Paige Miller
Ask a Question
Discussion stats
  • 3 replies
  • 76 views
  • 0 likes
  • 2 in conversation