I have tested at my end using value = (SELECT ADD_MONTHS(SYSDATE,3) FROM DUAL) and it works fine.
You check with value = (SELECT ADD_MONTHS(:PERSON.HIRE_DATE,3) FROM DUAL) and it should work because Hire date is of DATE type.
Pl. retest it.
Hi Sanjay good Morning ,
I tried with = (SELECT ADD_MONTHS(SYSDATE,3) FROM DUAL) and still issue exist.
It produces the Date as 09-JAN-0013 , instead of 09-JAN-2013.
One intresting thing observed , once I come back to form and it ask do you want to updated the record , If I Say Yes and its updates the record by changing the value from 09-JAN-0013 to 09-JAN-2013.
I am guessing something on the form level super seeds the personalization , isn't it ?
I tried many ways but no fruitful results.
I just thought of one more way but I dont know how to do that ...
That is , If we can get the form ( i.e Assignment Form - PERWSHRG ) actual code and check for what it is doing or using which type of Date mask and use the same in the personlization ,would it work ?
Just gueessing , correct me if I am not in a right path.
Before going thru Form, pl. check in the following way and confirm that whether datatype of hire date is DATE or DATETIME ?
Can you check DATATYPE & FORMAT MASK of field : hiredate ? You can navigate thru following path for datatype :
Place the cursor on Hiredate field > Help > Diagnostics > Properties > Item > Select Propery = Datatype You can navigate thru following path for format mask :
Place the cursor on Hiredate field > Help > Diagnostics > Properties > Item > Select Propery = format mask
Hi Sanjay thanks for looking at this again.
Yeah I had a check as you suggested ,
The Hire date is of Type Date and the Format mask is BLANK.
FYI : I read few oracle notes, few of them suggest not to personalize the " Combined Person and Assignment' Form.
Its heffty form.
I am just thinking other alternative for this. If I get it done will communicate on the thread.THanks for your suport.
Thanks and regards