How to compare if date is in between two dates.

[Farhad]

I have a report that binds to view. Every record has an "Employee Joining date" date field with it.

I have to filter out records ; whose joining date is with in two different dates.

How will i set "selection Criteria"; as i dont have any idea of the crystal reports syntax.

SOme refrence or sample will be valuable for me.

PLz. reply soon

Thanks in advance

[harmonycitra]

Give the folg. in ur selection formula

{join_date} in {?start} to {?end}


join_date => ur database field

start, end => parameter fields

Hope this will work

[ray5]

what i see is that the date in crystal report is consist of time too...
so how to get rid of the time, so that i can get only the date?

[Madhi]

Originally Posted by ray5

what i see is that the date in crystal report is consist of time too...
so how to get rid of the time, so that i can get only the date?

Use Cdate Function

Cdate(DateTimeField)