I have the following expression in a server job transformer:
I can guess that it returns the month in yyyymm format. But can someone please explain what the function DataTypeAsciiPic9 does? And is my understanding correct?If Not( IsNull (ProcessDate) )
Then (DataTypeAsciiPic9(DateYearFirstGetYear(ProcessDate) : DateYearFirstGetMonth(ProcessDate)))
Else @NULL
Thanks,
Vinod