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.
+13Hi @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
+20I’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.
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
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.