Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Process Flow Data Comparison

2 Replies

0 Subscribed to this topic

53 Subscribed to this forum

Sort:

Author

Messages

Chad Dirst

Advanced Member

Posts: 42

New Poster

3/20/2013 1:24 PM

Thank you for taking the time to review my issue.

I am trying to compare an employees termination date to today's date - 30 days. However, my current setup/logic is not working.

Here are the variables I have defined and the condition I am using.

Variables defined in Start Node
localCurDay = today()
localCurDay1 = AddDay(localCurDay,-30)
localCurDay2 = getDateDME(localCurDay1)
localCurDateM30 = pfDate(localCurDay2,"yyyymmdd")

Javascript condition located in Branch Node:
(GetEmployees_TERM_DATE=="") || (GetEmployees_TERM_DATE >= localCurDateM30)

Thank you in advance.

Woozy

Veteran Member

Posts: 709

New Poster

3/20/2013 2:28 PM

I'm not sure, but it appears you are trying to compare a string date (GetEmployees_TERM_DATE) with a javascript date (localCurDateM30).

Try this instead: (GetEmployees_TERM_DATE=="") || (GetEmployees_TERM_DATE >= localCurDate2)

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

3/20/2013 2:36 PM

Use this in your branch:
GetEmployees_TERM_DATE =="" || GetEmployees_TERM_DATE >= DateString(AddDay(today(),-30),'yyyymmdd')