From the catalog I am bringing in a date field (i.e. 06/28/2002). I have created a prompt to filter Start Date and End Date. The customer wants the date in the format of (dd-mon-yyyy). I've created the string (finally managing to convert date to string, substring, etc.) and am showing 28-Jun-2002 in the actual report. However, when the prompt displays, unfortunately it shows both 06/28/2002 AND 28-Jun-2002 (1 each for start date and 1 each for end date). Anyone know of a work around for this? I've tried creating as catalog prompts and report prompts, etc. Thanks in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.