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
View originalI 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
View originalHi
=Concat( CStr(Year([SOOrder.OrderDate])) , Cstr('/') , CStr(Month( [SOOrder.OrderDate])) , Cstr('/') , CStr(Day([SOOrder.OrderDate])))
Also attached screenshot for reference.
Hi
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]))))
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.