Need help with FRL date fields in xlate concat

[April Dunbar]

Hello,

I am having trouble with a concat that is trying to pull frl fields PostingDate_Year, PostingDate_Month and PostingDate_Day into 1VRL field (PostingDate).  The problem that I am finding is that on some of the values, it PostingDate is only displaying year.  Others will show year and month.  Yet others will do as it should and display year, month and day.  

I tried adding in a table for it to pull from and that seems to help on some cases, but not all.  I verified that field lengths are set accurately and tried changing around the character type from date to numeric to string.  

Any other suggestions or solutions that have worked for others?

Thanks, April

Topic

[Jim Kosloskey]

April,

Are the frl fields properly populated but when concatenating, the VRL field is not properly populated?

Do you have some examples?

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies