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 Laura02
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):
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:
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):
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.