AnsweredAssumed Answered

Termination Date

Question asked by vivianfulk-tiaa-cref on Aug 30, 2011
Latest reply on Mar 27, 2012 by another_martink
Hi all,

I am having an issue with Resource Termination date. Try this with one of your resources and see if this is also the case for you.

1. In the UI List View the term date is 8/26/11

2. In the UI Edit view the term date is 8/26/2011

3. Export list view to Excel shows 8/25/2011 0:00

4. In Oracle SQL Developer
select date_of_termination, trunc(date_of_termination) from srm_resources
shows 27-Aug-11 for both

I created an exception portlet to compare the termination dates from our HR system to Clarity and used "where trunc(srm_resources.date_of_termination) - 1 <> HR.term_date"

#1 is this correct?

#2 What gives with the export to Excel?
My user thinks that the date in Excel is the correct one - 8/25/2011.... and my query shows 26-Aug-11 which is what the UI shows. I think this is correct but just thought I would ask?

Thanks for any insight.

Vivian Fulk