Skip to main content
Solved

Generic Inquiry date output & formating


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
  • 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 Boga
Captain II
Forum|alt.badge.img+19
  • 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]))))

 

 


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