SQL Problem 1

[gscheepers]

Hi,

I have a problem with a sql that I'm trying to run to update a field according to data that's in an existing field.

My fields/tables is as follows:

Unemprd_cod/PSBPartners
PTRUnemp_dat/PSBPartners (This is date field)

The field that needs to updated is Unemprd_cod/PSBPartners.

This is what I'm trying to do:

If PTRUnemp_dat minus todays date is between 0 months and 6 months then Unemprd_cod = 01

Any help would be greatly appreciated!

Thanks, Gerhard Scheepers
BA - LETEC

 

[jimbopalmer]

Update PSBPartners set Unemprd_cod = 01
where (PTRUnemp_dat - sysdate) between 0 and 182
I tried to remain child-like, all I acheived was childish.