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

OIC Date Comparison Logic

Question
6
Views
0
Comments
edited Aug 13, 2021 4:03PM in Data Integration

Summary

Trying to use a date comparison in a switch -errors with no message

Content

Hi,

I am trying to apply a date comparison in a switch.

Date format I am passing in is 'YYYY-MM-DD' (Start Date)

I have tried the following

Start Date > string (xp20:format-dateTime (fn:current-dateTime(), '[Y0001]-[M01]-[D01]' ) )

Start Date > fn:current-date

xsd:date($currentWorker/nsmpr7:thisWorker/nsmpr7:start_date) > xsd:date(string(xp20:format-dateTime(fn:current-dateTime(), "[Y0001]-[M01]-[D01]")))

All are failing at the switch with no error message recorded.

When I log the values in a log file the formats match for approaches 1 & 3 above.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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