Skip to Content

User Response date

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)''

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Mar 07, 2017 at 12:52 PM

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

    is Date the prompt text?

    =UserResponse (''Date'')

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 12:56 PM

    Hi,

    You have to use format-date function try this

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

    Add comment
    10|10000 characters needed characters exceeded