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

Display Date Prompts in Global Format

edited Dec 13, 2022 6:56AM in Taleo Enterprise

Content

I have a requirement to display the dates the user entered into the prompt on the report in standard global date format "d Mmmm yyyy". I know there are different ways to display the dates but have come up with the following formula to take into account whether the user entered a timestamp. (I saw other options such as using POS function)

="Application Create Date: " +

FormatDate(ToDate(UserResponse ([Query];"Enter Application Creation Date (Start):");

If(Length(UserResponse ([Query];"Enter Application Creation Date (Start):"))>12;"M/d/yyyy hh:mm:ss A"; "M/d/yyyy")); "d Mmmm yyyy")

+ " - " +FormatDate(ToDate(UserResponse ([rQuery];"Enter Application Creation Date (End):");

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!