I am trying to calculate the Days to Fill for our Recruiting team. I am using the HRS_ROW_UPD_DTTM which is a date/time field but I cannot figure out how to change this to a date field so I can then use the DateDiff to find the days between my 2 fields. I am not even 100% sure using the DateDiff will work, but until I can get this field into a date format, I will never know.

Thanks for any help provided.

Views: 81

Reply to This

Replies to This Discussion

If you put the value of this field into a Date object you should then be able to work with the relevant PeopleCode functions.

Alternatively, try the sub string example given here.

Thanks alot for the information this was really helpfull.

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)


PeopleSoft Jobs in US


  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service