In Dw 9 I am trying to add conditionals to my activity as described in section "Applying conditions dynamically" on http://doc.dynamicweb.com/documentation-9/integration/for-dw-partners/data-integration-module.
By default I would like to have output for all table rows added less than a month ago, but I would like this "from date" to be able to be overridden in the URL.
A conditional seems to be the easy way to go.
When I do not add any conditionals I get a working activity with correct output.
When I literally copy the sample conditional {{DateDelimit||2015-01-02}} and add it to a DateTime form field with a "greater than comparer", then I get:
* Starting job - myJob
* Job failed: Failed to open sqlSourceReader. Reason: String was not recognized as a valid DateTime
* Finished jon - myJob
* Batch failed.
I also tried 2015/01/02, but that didn't help.
I also tried 02-01-2015, but that didn't help.
I also tried 2015-01-02 00:00:00, but that didn't help.
I also tried 2015-1-2, but that didn't help.
Eventualy I would like {{DateDelimit||@Code(System.DateTime.Now.AddMonth(-1))}} to work, which obviously doesn't work either at the moment.
Am I doing something wrong here? #FeelingStupid
Just putting a date in there does work, but I want it to be able to be called by URL ...
