Showing results for 
Search instead for 
Did you mean: 

Prompt date value to character

Former Member
0 Kudos


I got error "invalid number" when changing the prompt date to character

to_char( @Prompt('Please enter Settlement Date From','D',,mono,free),'MM/DD/YYYY')

Any idea?

Thank you


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Charing,

It depends on your date locale. The format generally includes the time. Use the prompt as a date first and see what WebI offers you on the format then use a matching format string. It generally includes the time as well so it should be DD/MM/YYYY hh:mi:ss

Hope this helps


Answers (0)