BN29 Offer Date is wrong

When I create data with the BN729, the dates in the "ACAOFRCSV" file are as expected, but then when I import "ACAOFRCSV" file the offer date gets messed up. For example an offer date on starts out as "1/1/2015" but then after I run the BN529 the date look like "01/12/0150". When I bring up the offers on BN29 they are found using the year "0150". I am guessing there is a patch for this that I am not finding or am I missing something else ?

-trey

Attachment_4330.zip

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

sriman-shivakoti

Did you open the csv file in excel and then resave it? If you opened it, did excel change the date format? Sometimes we have issues with that.

unknown

Yes, I had this same issue. I changed the date format in Excel to mm/dd/yyyy then saved to csv

0911060553270289.pdf

unknown

I don't believe so, I used a text editor (NotePad++) to view the file, the data is still in the "mm/dd/yyyy" format which looks to be what it comes from the BN729. I will create a new test file to confirm.

rgomez1

Did you check the date format in the jobdef for your BN529?

sriman-shivakoti

The good news is you can delete all the offers on the BN79

unknown

Did some quick testing... Looks like I had used Excel. I just redid the process and it looks correct now. Thanks Guys.. If only all the issues where this simple. :-)

unknown

My first opportunity to use BN79, that worked too, Thanks all.

Copyright © 2025 Infor. All rights reserved.