Hi Koksoon , on the first line of the log, a value 44705 appears:
S I N O W E L L I N T E R N A T I O N A L P N G L T D S O H O E N T E R P R I S E - R A B A U L R A B A U L X 4 4 7 0 5 2 0 2 3 - 9 - 2 1 0 0 4 3 1 1 6 ( 0 7 . 1 4 ) P 5 2 0 0 0 " $ 8 , 2 5 7 . 0 0 " " $ 9 , 0 8 2 . 7 0 " S U P E R M A R K E T G S T $ 0 . 0 0 $ 8 2 5 . 7 0 $ 0 . 0 0 G S T $ 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 B 5 1 3 0 $ 0 . 0 0 * N o n e 1 0 7
That value is a date number in Excel which has been converted to a value. You need to format the date column as dates before saving as a text file.
Hi, Mr Mike,
May i know how to format the date column from the excel ? Appreciate you can let me know. Thanks a lot for your reply.
Regards
Kok Soon
Hi Koksoon , dd/mm/yyyy will work.
Hi, Mr Mike,
Already tried to format all dates from the excel and import the data again, result still the same, error on invalid date. For your information, the number you highlighted with red colour 44705 is purchase number.
Regards
Koksoon
Apologies, I wrote too soon. The date next to it (2 0 2 3 - 9 - 2 1) should be in dd/mm/yyyy format.
