You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Newer of two dates

Received Response
31
Views
2
Comments

Summary: I'm looking for logic that will allow me to pull in two different types of hire dates (new hire date, re-hire date) and return the most recent date. Would I do this with a CASE/WHEN statement?


Content (required):We have multiple hire dates in the system (new hire, re-hire dates specifically) and I need to be able to return the most recent hire date regardless if its the original hire date or the re-hire date. Is there a way to pull that?


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!