Help with expression in rdlc report (VB 2005)

Posted on 2009-12-23
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?

Question by:FOS-Bret

    Author Comment

    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".
    LVL 48

    Accepted Solution

    You don't have that namespace available in the Expression Editor. You need to indicate the full path:


    Author Closing Comment

    Perfect! Thanks for the help. I appreciate it.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    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…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now