I'm trying to display YTD Tot_Sales. In the Data Environment Designer I created an expression that tried to convert del_date (8 char., string, yyyymmdd) and find it in YTD. It seemed so simple. But I continously received an invalid scalar function error. Pervasive's website acknowledged the problem and will consider a fix in the next version. How can I work around this? I considered using Left (del_date, 4) and comparing it with the system year. What do you think of that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
converting string to date for YTD filter
- Thread starter dmccallum
- Start date
Similar threads
- Locked
- Question
