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?