ACC - List of function DateOnly

[Yamila1981]

Buenas tardes,

Someone tried to use the DateOnly() function on a field to keep only the date

When I go to see what it returns in the data view I have the real EventDate data and the data with the function applied and it continues to return time when I only expect the date

Do you know what I'm doing wrong or what else I need to take into account?

Cheers

[imicu]

Hi,

As indicated in the documentation the Dateonly() function returns returns the date only (with time at 00:00)

You can use ToDate(@eventDate) to converts a date + time as a date.

[ParthaSarathy · Accepted solution]

Hi @Yamila1981 ,

You can use ToDate() function to retrieve date only

Example, ToDate(@eventDate)

[Yamila1981]

Thanks ParthaSarathy, it´s work!!!

[Shubham_Goyal__]

Hi @Yamila1981 ,

DateOnly() always returns a date with time 00:00.
Try to use the ToDate(@eventDate) function instead of DateOnly() so that it returns you only date.

Cheers,

Shubham

[Yamila1981]

Thanks _Shubham_Goyal_!!! It´s work.