Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 346
	Members: 0
	Total: 346

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

Process Flow Data Comparison

2 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

Chad Dirst

Advanced Member Send Private Message

Posts: 42

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 Send Private Message

Posts: 709

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: 3351

3/20/2013 2:36 PM

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