You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get date to return mm/dd/yyyy with no timestamp - figured out use MM/dd/yyyy

Accepted answer
36
Views
3
Comments
Madeleine Mirand
Madeleine Mirand Red Ribbon
edited Jul 14, 2015 7:40PM in Reporting and Analytics Taleo Enterprise 3 comments

Best Answer

  • Terrie Whisenant
    Terrie Whisenant Red Ribbon
    edited Jul 14, 2015 7:51PM Accepted Answer

    Go to the date column in the criteria tab. Go to column properties > data format. Check override default data format > select custom and the change the custom date format to be [FMT:date]. This will drop the timestamp. Hope this helps.

    Terrie

Answers

  • Kristine Kukich-Oracle University-Oracle
    edited Jul 14, 2015 7:47PM

    Madeleine - After you select the date format that you like, then click in the drop down list a second time and scroll all the way to the bottom.  There you should find Custom.  This will allow you to edit the Custom Date Format blank, where you should be able to remove the timestamp info and just keep the date.

    Good luck

    ---kristine smiley

  • Madeleine Mirand
    Madeleine Mirand Red Ribbon
    edited Jul 14, 2015 8:35PM

    Thank you! That works just like the MM/dd/yyyy.