Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Add New Column Based on Days Between Two Dates Result — Cloud Customer Connect
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

Add New Column Based on Days Between Two Dates Result

Accepted answer
1
Views
6
Comments

I'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Date and Termination Date. I need to add a new column (identifying whether or not a 28 day notification was given) where if the number of days from that formula is >=28 then "Yes", else "No"

TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Termination Notification Date", "Worker"."Termination Date" )

I would appreciate advice on how to do this please.

Content (required):


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!