myPeopleSoft

PeopleSoft Community Network

Subtracting a datetime field and a date field

Hello,

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.

2 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Melia Ruf on July 1, 2013 at 6:30am

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.

▶ Reply

Permalink Reply by Beryl Masone on July 1, 2013 at 7:55am

Thanks alot for the information this was really helpfull.

▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:01pm

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)