[SOLVED] issues with date related functions during migration
we are in a migration phase from ISM 6.1 to ISM 8.
one of our integration reads a file which has the following data
SOME-NMAE -10 1
then we have a series of nested IFL functions that constructs a date out of the and based on passed values. 1 stands for today and -10 is go 10 days back from today to find some information.
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
February 19, 2019, 09:05 AM
satish chennupati
aha Darryl i understood now as to what you meant.
thanks it worked for me.
Data Migrator 7.7 service manager 6.0, 6.1, 6.5 and 8