Number of days in a year can be calculated by finding the 1st day of the next year and subtract that from the 1st day of the current year.
Find first day of next year
Find first day of current year
Finding days for the current year is an easy task now, just subtract the two dates and your done.
|How to insert or update the Peoplesoft table by reading the key field from input file||PeopleSoft Technical||08/14/2014 - 6:15am|
|Datetime difference between two timestamps excluding weekend(sat,sun) in SQL||SQL & PL/SQL||08/14/2014 - 5:25am|
|Default the value on Look up Page,when I click on prompt button on the page.||PeopleSoft Technical||08/06/2014 - 4:32am|
|Unable to change hiring manager||PeopleSoft Technical||06/25/2014 - 1:34am|