Date_Format_Issue

building reports webintelligence legacy
1

Hi All,

We are facing some date issue.We are using the From and End date:

=FormatDate(ToDate(UserResponse(“1.Enter the Training Start Date (DD-Mon-YYYY):”);“d/M/yyyy hh:mm:ss a”);“dd-Mmm-yyyy”)

When we pass the date as 7/1/2015 it is working fine.When we give 8/14/2015 then will face Error.Please refer the screenshot.

But the error is appearing in Webi Rich cleint and in infoview it is working fine.

Regards
Rohit k

Rohit77 :india: (BOB member since 2005-10-24)

2

Please find the attachment
Date_Issue.doc (32.0 KB)

Rohit77 :india: (BOB member since 2005-10-24)

3

8/14/2015 doesnt match the format the prompt is expecting?

DD-Mon-YYYY

Mak 1 :uk: (BOB member since 2005-01-06)

4

Hi Mark,

were i need to use =FormatDate(ToDate(UserResponse(“1.Enter the Training Start Date (DD-Mon-YYYY):”);“DD-Mon-YYYY hh:mm:ss a”);“DD-Mon-YYYY”)

I have changed the formula still i am getting the Error.

Please advise

Regards
Rohit k

Rohit77 :india: (BOB member since 2005-10-24)

5

Changing the formula won’t help.

The prompt is expecting DD-Mon-YYYY for both date parameters.

8/14/2015 should be entered as 14/8/2015

Mak 1 :uk: (BOB member since 2005-01-06)

6

Hi Mark,

The date is appearing correctly till 12-Aug-2015.After 12th it is giving #Error.

Please advise the correct formula.

Regards
RK

Rohit77 :india: (BOB member since 2005-10-24)

7

As I said you will get the error if you do not follow the DD-Mon-YYYY format in the prompt entry.

I cannot be more clear than that :roll_eyes: .

Mak 1 :uk: (BOB member since 2005-01-06)

8

Try 14/8/2015 and see what happens