How to do the first date of the year in command

[kate8]

I have a report that needs to be ran by schedule. So I need to set the time range to the first date of the year to the current date in Command. Here is what I am doing, but does not work in command:
register_date between date(year(currentdate),1,1) and sysdate
date(year(currentdate),1,1) works fine in the formula, show 1/1/2017. But does not work in command, Even I replace currentdate with sysdate, still got the error:
Failed to retrieve data from database. Detail: ORA-00936. Missing expression
How can I set the report run with the first day of the year in Command? Is it possible? Thank you very much for any help!!!

 

[kate8]

Hi,
I figured it out.
In command, the query syntax should work for your database. Since my report runs against Oracle database, so I do the following and it works.

register_date between TRUNC(sysDate,'YEAR') and sysDate

Hope that will help anyone who has the same issue.
Thanks!

 

[hilfy]

This didn't work for you originally because you can't use Crystal functions in a Command - you can only use the syntax that's specific for your database. Also, the syntax you posted only works with Oracle. If you're using a different type of database, you'll use different syntax.

For more information about using commands, go here:

https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com