As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
it takes the fromDate and toDate based on the numeric values passed and constructs a date using these. A negative value represents past date so here toDate will be today's date and -10 will be 10 days before.
in ISM 6.1.2 it is working fine (see the extract of log file)
but when i migrated this pflow to ISM 8.0.1 it is not working anymore. (see log below)
Exception in execute of _fmtdate('yyyy', _dateof('yyyy/MM/dd',_sreg('Fdate'))): XD[FAIL] cause: 0 subcause: 0 message: Unable to process function expression for function: dateof, parameter: 2; Value ''-10'' is not a valid date per the format in parm 1
i want to understand what i should modify so that it will work properly and constructs the dates.
from the release notes i only understood that instead of _now we need to use _timer which i tried and that didnt worked.
Data Migrator 7.7 service manager 6.0, 6.1, 6.5 and 8