?
Solved

Help with expression in rdlc report (VB 2005)

Posted on 2009-12-23
3
Medium Priority
?
628 Views
Last Modified: 2013-12-20
Hey All,

Using VB.NET (2005), OLEDB, and a data report.

I have a date stored in the (Jet) DB as a string. I want to use the "FromOADate" function to bring it back to a date. In the expression builder, though, I get the squiggly line below the "FromOADate" part of the expression and when I type "date." in the expression, "FromOADate" doesn't come up on the Intellisense listing.

I use the same formula elsewhere in my program. Can someone tell me how to get the Expression Builder in the report to recognize the function?

Thanks,
Bret
VSNoLikeyFromOADate.gif
0
Comment
Question by:FOS-Bret
  • 2
3 Comments
 

Author Comment

by:FOS-Bret
ID: 26114640
By the way, although the date is stored as a string in the database, it's a string representation of a double. For example, right now would be "40170.5226851852".
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 26114652
You don't have that namespace available in the Expression Editor. You need to indicate the full path:

=System.DateTime.FromOADate(Fields!EADateString.Value).ToShortDateString
0
 

Author Closing Comment

by:FOS-Bret
ID: 31669536
Perfect! Thanks for the help. I appreciate it.
Bret
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month15 days, 19 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question