Comparing dates in IPA - PfiWorkUnit StartDate

Hi Preston Burdwell,

Unfortunately, it's more complicated than that. The Landmark query returns WorkUnit.StartDate as a string in the format of ccyyhhmmhhmmssss (the timestring is very odd - I'm not sure what it's doing). However, it is not returned as a jsDate but as a string. However, today() is returned as a jsDate which includes the timestring. What I think you need to do is convert both to AGS format (ccyymmdd) and then compare those. You can't compare them as jsDate because of the timestring difference:

StartDateAGS (string) = getDateAGS(pfDate(lmGetWorkUnit_StartDate,'yyyymmdd'))
YesterdayAGS (string) = getDateAGS(AddDay(today(),-1))
WUYesterday (Boolean) = (StartDateAGS == YesterdayAGS)

Good Luck!

you've got a couple options here:
1. do a substring on the PfiWorkunit.startdate to return a CCYYMMDD format (variable name = StartDdate.substr(0,8), then run the results thru some of the routines that Woozy has shown
2. query PfiWorkUnit for "DaysInElapsedTime" field. it'll return a whole number, which SHOULD work for you...i'm trying to think it thru on the fly, but Day = 1 should be what you want...just add the "& failed" logic.

Awesome suggestions! I placed an Assign node after the LM Node and assigned the Landmark StartDate (TimeStamp) to the following: StartDateAGS (string) = getDateAGS(pfDate(lmGetWorkUnit_StartDate,'yyyymmdd'))
Comparing the StartDateAGS variable to my calculated "Yesterday" variable gives me the workunits I need. Thanks!!