Skip to main content

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? 

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


Hello @jddonnell55 ,

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:




​​Results:
 

What am I doing wrong?


Reply