You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Date calculations in peoplecode

1 reply [Last post]
Guest's picture
Guest

given a date How do I write a date function or peoplecode functionality to return the 1st business date.

Guest's picture
Guest (not verified)
Re: Date calculations in peoplecode

Not sure about the 1st business date you may need to use two different exec statements

try something like this with SQLExec ("select last_day(to_date(:thedate)) + 1 from dual")
may need to use the %datein or %dateout