Hi friends,
I have to create a report to track if anyone worked on any work order after 5:00 PM or on weekends. Suppose I worked on work order till 5:30 then in report it should show that time exceeded or if someone has worked on weekends then it should say the its Sunday or Saturday (something like that).
I have work order start time to catch this but I am not getting how to use decode or any function to track it.
Can anyone give me idea how to this.
Thanks in advance.
Anju
I have to create a report to track if anyone worked on any work order after 5:00 PM or on weekends. Suppose I worked on work order till 5:30 then in report it should show that time exceeded or if someone has worked on weekends then it should say the its Sunday or Saturday (something like that).
I have work order start time to catch this but I am not getting how to use decode or any function to track it.
Can anyone give me idea how to this.
Thanks in advance.
Anju