Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Stealth "mini-patch" 12-20-06 evening changed my custom date fields to date time.HELP
I have several crystal reports that use custom date fields and sort them out by weektodate monthtodate and yeartodate. There was a stealth patch on 12-20 that changed all these fields from date to datetime so now my reports no longer work. How can I change these reports to work with year to date etc?
Even a simple record select statement of
{field} in yeartodate
returns the error:
Failed to open a rowset
Details: 26000:[OpenAccess][openRDA ODBC]Invalid SQL statement identifier
What can I use instead of {field} in yeartodate to achieve the same thing? Maybe a statement to strip the time off the date field so its in the right format?