The syntax in the define field GUI's seem to leave me stumped . I am in Advanced graph Assistant and I want to assign numbers to my week days so I can sort them properly. I have entered :

IF UM_PEND_DIS_DTL.UTIL_PENDING_DISCH_DTL.WKDAY EQ '' Sunday '' THEN 1 else 0

and I am getting back a syntax error message . Can anyone tell me what the syntax should be ?

This message has been edited. Last edited by: Kerry,

Try single quotes and a semi-colon terminator.

Thanks the single quotes fixed it!!

Is this a DATEFIELD or a string?
If it a date then it has already an internal sequence number. Else use the decode function.

It is a string that shows the day name. What is decode and what does it do?

Decode is a function that converts whatever is coming from your source to your specifies value.

DECODE fieldname(code1 result1 code2 result2...[ELSE default ]);

DECODE DAYNAMES(Sunday 1 Monday 2 etc ELSE 0);

Thanks Alex that is very cool. It will meet my needs better than an if.

I did finally get the IF syntax to work ( limited) it should have been

IF UM_PEND_DIS_DTL.UTIL_PENDING_DISCH_DTL.WKDAY EQ 'Sunday' THEN 1 else 0