Skip to main content
Solved

Generic Inquiry date output & formating

E

I need the date output in a GI to be yyyy/mm/dd for a third party integration but we use mm/dd/yyyy as a default. How can I flip this around?

Best answer by Naveen Boga

Hi @ebaker  We can do with the below formula. 

=Concat( CStr(Year([SOOrder.OrderDate])) , Cstr('/') ,  CStr(Month( [SOOrder.OrderDate])) , Cstr('/') ,  CStr(Day([SOOrder.OrderDate])))

 

Also attached screenshot for reference.

 

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

    2 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3393 replies
    • Answer
    • June 16, 2022

    Hi @ebaker  We can do with the below formula. 

    =Concat( CStr(Year([SOOrder.OrderDate])) , Cstr('/') ,  CStr(Month( [SOOrder.OrderDate])) , Cstr('/') ,  CStr(Day([SOOrder.OrderDate])))

     

    Also attached screenshot for reference.

     

    Naveen B
    Kandy Beatty
    Chris Hackett
    E
    3 people like this
    • Kandy Beatty
      Kandy Beatty
    • Chris Hackett
      Chris Hackett
    • E
      ebaker
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3393 replies
    • June 19, 2022

    Hi @ebaker  You can also try with the below formula, which can add the 0 before the DATE and MONTH if the value is less than 10

     

    Concat( CStr(Year([SOOrder.OrderDate])) , Cstr('/') , 
    IIf(Month([SOOrder.OrderDate]) < 10, '0'+CStr(Month([SOOrder.OrderDate])), CStr(Month([SOOrder.OrderDate]))) , Cstr('/') ,  
     IIf(Day([SOOrder.OrderDate]) < 10, '0'+CStr(Day([SOOrder.OrderDate])), CStr(Day([SOOrder.OrderDate]))))

     

     

    Naveen B
    Kandy Beatty
    1 person likes this
    • Kandy Beatty
      Kandy Beatty

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    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
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved