Skip to main content

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

 
thank you

 

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

@JavierGtz  Another simple solution. 

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.

 

 

 

@JavierGtz  Another simple solution. 

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 @Naveen Boga now its showing only the date.

Reply


Terms & ConditionsCookie settings