BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

[Deski (XI)] Error: Incorrect data type DMB003 - DeskI


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
remahesh
Forum Member
Forum Member



Joined: 09 Aug 2006

Posts: 8



PostPosted: Tue Oct 10, 2017 2:56 am 
Post subject: Error: Incorrect data type DMB003 - DeskI

Hi,

I have created a variable in WebI which I am comparing two dates (Start & End dates).

The below variable/syntex is working fine in WebI however if I use the same logic in DeskI it's not working (Error: Incorrect data type DMB003)

WebI Syntex - It works perfectly
=If ( ([Start Date] <= [End Date] ) Or ([Start Date] >= [End Date] ) ) Then " " Else Max([Start Date])
Output
Start Date End Date
01/08/2017
01/12/2017
01/10/2017

In DeskI - Using BO3.2 version
=If ( (<Start Date> <= <End Date> ) Or (<Start Date> >= <End Date> ) ) Then " " Else Max(<Start Date>)
I am getting Incorrect Data Type (DMB0003).

I am not sure where I am doing mistake.

Much appriciate your help to resolve this error.

Thanks
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6231
Location: Connecticut, USA


flag
PostPosted: Tue Oct 10, 2017 6:48 am 
Post subject: Re: Error: Incorrect data type DMB003 - DeskI

The results of the "If" and the "Else" have to be of the same data type. In your case, the result of "If" is a string (""), and the result of "Else" is a Date. Try using FormatDate() to convert the date to a string.
Back to top
remahesh
Forum Member
Forum Member



Joined: 09 Aug 2006

Posts: 8



PostPosted: Tue Oct 10, 2017 6:55 am 
Post subject: Re: Error: Incorrect data type DMB003 - DeskI

Hi Joe,

Thnaks for your comments.

I have resolved the issue.

Created a variable TEST-1 with date value as 01/01/1900 using FormatDate() and created second variable TEST-2 and converted that 01/01/1900 as " ".

Its' working...
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0119 seconds using 17 queries. (SQL 0.0022 Parse 0.0002 Other 0.0095)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo