Skip to main content
Solved

Import Scenario - Date - Just need date, not time


Forum|alt.badge.img

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):

More date formulas from  Naveen:

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • November 27, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 40 replies
  • November 27, 2023

That did not work.  Here are my screens:

 

Import Scenario:

Data Source:




​​Results:
 

What am I doing wrong?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • November 27, 2023

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


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