Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX Sum Hours Validation

395cac86-2e00-495e-9737-e8f1ffee344cFeb 23 2016 — edited Feb 23 2016

Hello,

I am having a little trouble creating validation on my Timesheet application. I am trying to ensure that only 24 hours can be saved to any one day. Currently I have a validation in my 'Form on Timesheets' that ensure time entered must be between 0.25 & 24.00 however entries can be modified in my 'Timesheet Details' report to any number. See below

Capture.PNG

I am trying to use an if statement validation with the sysdate clause however this doesn't appear to be working. I would be grateful for any help resolving this matter.

Capture1.PNG

Regards,

NMS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2016
Added on Feb 23 2016
#apex, #apex-discussions, #validation
1 comment
418 views