persian date problem in oracle form6i
I am working with oracle form 6i and I wanna have a Shamsi date on the field which has the Date data type, I add the NLS_Calendar = Persian on the registry, and NLS_CALENDAR_FORMAT = 'YYYYMMDD'.
the each date will show on the form in Shamsi format except for one date which is the first day of the first month of each year like '13860101' or '13450101' ,... when I enter for exaple 13820101 and press the tab button the date shows me like #########. what is the solution for solving this problem?!
Regards,
Mina
|