want to know the sql code/formular to use when compairing date datatype in crystal report eg.want to produce weekly, monthly,yearly reports of my database.