DateADD, DateDiff, DatePart???

[records333]

I would like to capture PAT_ENC.APPT_TIME in last 24M from 11/26/2012, but I'm getting boolean errors:

{PAT_ENC.APPT_TIME} in Dateadd ("m-24", 2012,11,26,00,00,00)

 

[fisheromacse]

i do not have crystal in front of me, so apologize for any errors, but think that you are missing part of the date range in your statement.
Something like below is, i think, close to what you are looking for.

{PAT_ENC.APPT_TIME} in [Dateadd ("m-24", 2012,11,26,00,00,00) to datetime(2012,11,26,00,00,00)]

 

[records333]

Hi there! I tried your above recommendation but I'm getting an error of "too many arguments

 

[briangriffin]

Dateadd takes three arguments:

Dateadd ("m",-24, datetime("2012,11,26 00:00:00"))

I would suggest taking a look at Crystal help - these functions are especially well documented with plenty of examples. I use it all the time.

 

[fisheromacse]

still not promise my syntax is without errors, but maybe this change will help.
I separated the 'm-24' into the dateadd format i am used to seeing. '"m", -24'

{PAT_ENC.APPT_TIME} in [Dateadd ("m", -24, datetime(2012,11,26,00,00,00)) to datetime(2012,11,26,00,00,00)]

 

[records333]

Hi there, I will circle back and look in Crystal help- I tried the Brains and in error "a date-time range is needed

 

[records333]

Thank you both for your assistance. @fisheromacse- IT'S WORKING!!