Date and Time format

[cmutombo]

Hi Community

Please help

This below date :

2021-08-14 00:00:00.000000 is at which format ?? 

If I want to explain it to format  : '/M/DD/YYYY' for ex

[Kushal_Chawda]

@cmutombo  if  max([GROSS_ADDS.DATE_]) return any value then you can simply use below

 date(floor(max([GROSS_ADDS.DATE_])),'M/DD/YYYY')