date difference

[shukuo]

HI.

I am trying to retrieve records between

{@post_date} in {?BeginDate} to {?EndDate} or
{@post_date} in {?BeginDate} to {?EndDate}

and the previous year of beingdate and enddate, is there any quick function to do this ?


thanks.

 

[synapsevampire]

{@post_date} in dateadd("y",-1,{?BeginDate}) to dateadd("y",-1,{?EndDate})

Check the syntax, I don't have Crystal here, I'm going from memory.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kuo]

thanks so much.

it works, the type is "yyyy"