using currentdate function in a SQL Expression 1

[pl1101]

Hello, I am not sure if anyone has had this problem, but I am trying to use the date criteria in a sql expression. I can do it manually, but is there a way to make the field = month(currentdate)? When I put this in a sql expression it says column currentdate not in specified tables. What is it looking for?

Please help
Thank you!!

 

[IanWaterman]

Depends on your database.

MS SQL use Getdate()

Oracle use sysdate, but Oracle does not have the function Month(). You would have to convert to char, then extract string and convert to number.

Ian

 

[pl1101]

I am using AS400 and Crystal XI release 2

 

[lbass]

Ian,

Oracle does have a month function-> {fn month()}

Maybe it depends upon the driver used though.

pl1101,

Look in the field list for a function like "Now" or "Curdate". These functions can then be nested within the month function as in,

{fn month({fn curdate()})}

Not sure what functions are available for AS400.

-LB

 

[pl1101]

Great that worked. I did not know that Crystal gave other options in the field list. That will help me in the future. Thank you sooo much