Unable to add date to a field using import excel file in configuration package

(0) Share

Report

Posted on by Leo99

Created a new Configuration file.

Created the excel file for import

This is the Starting Date Column in Purchase Price table. When I imported the file, the starting Date column never got filled with the October 24th 22 value. It remained empty. The Starting date column is Date datatype. Any suggestions or corrections to get the date filled.

Thanks in advance for your time.

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

What other table do you have in your excel sheet?

As i minimum you need all primary keys fields in the table you want to create the import for.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 102,389 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, you can fill in a date first in BC, and then export the row. Enter a new line according to its format.

For example, in my environment the date format is 2021-01-01.

Hope this helps.
Thanks.

ZHU

Was this reply helpful? Yes No
Leo99 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply Mr.Brunvik. I had all other values added to the DB except the date

Was this reply helpful? Yes No
Leo99 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mr.Zhu,

Thanks for the reply. It could very well be the format like you mentioned.

Was this reply helpful? Yes No