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
Â
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
Â
Hi @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
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.
Â
Â
Â
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.