ACC - List of function DateOnly | Community
Skip to main content
Level 2
Aug 22, 2022 7:40 PM UTC
Solved

ACC - List of function DateOnly

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
Aug 23, 2022 7:45 AM UTC

Hi @yamila1981 ,

You can use ToDate() function to retrieve date only

Example, ToDate(@eventDate)

 

 

 

 

 

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

5 replies

Shubham_Goyal__
Level 6
Aug 23, 2022 7:45 AM UTC

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

Translate
Level 2
Aug 23, 2022 9:13 PM UTC

Thanks _Shubham_Goyal_!!! It´s work.

Translate
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
Aug 23, 2022 7:45 AM UTC

Hi @yamila1981 ,

You can use ToDate() function to retrieve date only

Example, ToDate(@eventDate)

 

 

 

 

 

Translate
 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Level 2
Aug 23, 2022 9:12 PM UTC

Thanks ParthaSarathy, it´s work!!!

 

 

Translate
Employee
Aug 23, 2022 7:41 AM UTC

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.

Translate