Hello to everyone
Im doing a GI to show me the run out date, i already made to show me the date but it show me with the time.. how can i get to forces to show me only the date mm/dd/yyyy
Solved
Format Date GI
Best answer by Naveen Boga
Iām not sure what DACs that you are using in your GI, but if you any of the DAC is having the just a DATE field like (in the SOOrder, we have OrderDate is a just a field), you can mention field in the Schema field so that it will give you the simple DATE in your GI.
Here is an example for your reference.
+11Hi @JavierGtz
Please use the Concat function to concatenate strings as in the following example.
=Concat(CStr(Month([FinPeriod.StartDate])),'/' , CStr(Day( [FinPeriod.StartDate])),'/',CStr(Year( [FinPeriod.StartDate])))
Please refer to the post below.
Best Regards,
NNT
+19Iām not sure what DACs that you are using in your GI, but if you any of the DAC is having the just a DATE field like (in the SOOrder, we have OrderDate is a just a field), you can mention field in the Schema field so that it will give you the simple DATE in your GI.
Here is an example for your reference.
Naveen B - Acumatica MVP š | Independent Developer for Hire š ā© https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Naveen Boga wrote:
Iām not sure what DACs that you are using in your GI, but if you any of the DAC is having the just a DATE field like (in the SOOrder, we have OrderDate is a just a field), you can mention field in the Schema field so that it will give you the simple DATE in your GI.
Here is an example for your reference.
Thanks
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.