Greetings,
I have a date prompt for my report. If I declare the prompt type to be a date I get a calendar option. If I declare the prompt a string then I lose the calendar option.
I like the calendar option, but I want to enter my date in the format mm/dd/yyyy. Entering the date yyyy/mm/dd is foreign to everyone's thinking and fingers.
I have gone to file/options/fields/date/date and set the date format option to 'system default short format'. But, the parameters entry field continues to want the backwards date.
I understand that the data in the tables is in yyyy/mm/dd format and I can work around this with mid statements to flip my entered date for comparison purposes.
Is entering a parameter option in the mm/dd/yyyy order possible?
Thanks,
Rich