how to change the date format in Prompt ie dd/mm/yyyy to mm/dd/yyyy?

sapna

• Aug 29th, 2017

Formatdate(UserResponse("Select Start Date:"),"mm/dd/yyyy")

Srini B

 Profile Answers by Srini B Questions by Srini B

• Feb 2nd, 2012

In Oracle to_date(to_char(datecol, mm/dd/yyyy), mm/dd/yyyy)

Answer Question  Select Best Answer