tag:blogger.com,1999:blog-4007772006737635792.post7964904392506811674..comments2024-03-27T16:11:52.332+05:30Comments on Shyam's Blog | Oracle Cloud, Peoplesoft, Workday: Finding the 'n'th business day in PeopleSoft application using Oracle SQL queryShyamhttp://www.blogger.com/profile/08146888311621138779noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4007772006737635792.post-30437622474987691952013-01-31T05:17:10.319+05:302013-01-31T05:17:10.319+05:30Great post and thank you! Had no idea this was eve...Great post and thank you! Had no idea this was even possible with a single SQL.<br /><br />Is it possible to write a SQL using a similar logic to #6 or #7 where I can figure out how many days passed (excluding weekends and holidays) since a row added to a table?<br /><br />select row_added_dttm, total_business_days_excluding_holidays_weekends_since_row_added_dttm<br />from ps_anytable<br /><br />select row_added_dttm,( # of days(sysdate - row_Added_dttm) - (business_days + holidays))<br />from ps_anytableAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-65076157906848138262011-11-19T00:14:01.912+05:302011-11-19T00:14:01.912+05:30@FGravel,
Please share the code you are using and ...@FGravel,<br />Please share the code you are using and the error message returned.Shyamhttps://www.blogger.com/profile/08146888311621138779noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-16177845078887009632011-11-18T23:09:09.029+05:302011-11-18T23:09:09.029+05:30This is excellent stuff and I think at least part ...This is excellent stuff and I think at least part of the answer to what I'm trying to do. My problem is this: I adapted the example you give in #6 above into a peoplecode function to return a date X number of business days from a start date. I feed the function the start date and the number of business days I want to go forward. The SQL statement works fine as a query returning the correct date but errors in peoplecode. What am I missing?<br />fred.gravel@lethbridge.caFGravelhttps://www.blogger.com/profile/07842583612846501164noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-66021128756200464182010-02-07T04:02:36.183+05:302010-02-07T04:02:36.183+05:30Excellent one, thanks for the queries.Excellent one, thanks for the queries.Christienoreply@blogger.com