User Response date

[Former Member]

Hi guys,

i am new to BO i am getting error while creating variable with user response with date

= User Response (''Date'') when trying to validate getting below error

'' The date or time format at position 14 is not valid (IES 10035)''

[former_member199945]

Hi,

You have to use format-date function try this

= FormatDate(ToDate(UserResponse([Query 1];"Enter Start Date (PER):");"");"MM/dd/yyyy")

[amitrathi239]

There is no space in the userresponse. it's a single word.

is Date the prompt text?

=UserResponse (''Date'')