Have formatted the excel import file date field to not display the time. When imported into Acumatica, it brings a time stamp. Just need the date, not the time.
Have attempted setting the field on import scenario to “=TEXT([column name], “dd-mm,yyyy)”
This does not work.
Any suggestions?
Best answer by Laura03
Hello,
If you search “Format Date” there are a million ideas… I don’t know which ones will work in your specific situation until you try it out. Naveen used Substring Date, Month, Year on a Date field, to solve the question in this post (result does not display time):
More date formulas from Naveen:
Laura
+19Hello
Did you see the below post, answered by Daryl Bowman, about formatting a Date field with no time stamp (on a report, not an import), - I hope a similar formula may work for you:
Laura
That did not work. Here are my screens:
Import Scenario:
Data Source:
What am I doing wrong?
+19Hello,
If you search “Format Date” there are a million ideas… I don’t know which ones will work in your specific situation until you try it out. Naveen used Substring Date, Month, Year on a Date field, to solve the question in this post (result does not display time):
More date formulas from Naveen:
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
