Skip to main content
Question

IFS Cloud - Excel Migration Date columns

  • June 8, 2023
  • 1 reply
  • 121 views

Forum|alt.badge.img+6

Hi,

When using excel migration to upload data, when a date is passed, it gets inserted as the prior date. For example, if I am loading external payments with date 5/20/2023 in my excel, once uploaded and going into IFS, it shows as 5/19/2023.

The same behavior is observed when a new entity is created and excel migration is used to upload the data.

When the data is indicated as 1/1/2023, it uploads as 12/31/2022 automatically.

Is this the known behavior of excel migration? if not, what needs to be done to resolve this issue?

Best Regards,

Dinesha

Forum|alt.badge.img+6
  • Sidekick (Customer)
  • April 7, 2025

Hi Dinesha,
Did you manage to resolve this? We are seeing the same with Project Transactions this week we suspect it’s to do with daylight savings but we don’t know how to resolve it.

Thanks

Paul


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings