Skip to Content
0

User Response date

Mar 07, 2017 at 12:47 PM

49

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 07, 2017 at 12:52 PM
0

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

is Date the prompt text?

=UserResponse (''Date'')

Share
10 |10000 characters needed characters left characters exceeded
seshu P Mar 07, 2017 at 12:56 PM
0

Hi,

You have to use format-date function try this

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

Share
10 |10000 characters needed characters left characters exceeded