Display Date Prompts in Global Format
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):");