ACC - List of function DateOnly | Community
Skip to main content
Y
Yamila1981
Level 2
August 22, 2022
Solved

ACC - List of function DateOnly

  • August 22, 2022
  • 3 replies
  • 1761 views

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.
    Best answer by ParthaSarathy

    Hi @yamila1981 ,

    You can use ToDate() function to retrieve date only

    Example, ToDate(@eventDate)

     

     

     

     

     

    3 replies

    I
    Adobe Employee
    imicuAdobe Employee
    Adobe Employee
    August 23, 2022

    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
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    August 23, 2022

    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
      Y
      Yamila1981Author
      Level 2
      August 23, 2022

      Thanks ParthaSarathy, it´s work!!!

       

       

      Shubham_Goyal__
      Shubham_Goyal__
      Level 6
      August 23, 2022

      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

        Y
        Yamila1981Author
        Level 2
        August 23, 2022

        Thanks _Shubham_Goyal_!!! It´s work.

        Terms & ConditionsAccessibility statement

        Loading footer...