• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 774
  • Last Modified:

How to compare date in crystal reports viewer.


how to compare dates in crystal reports' selection formula.

I want to apply selection criteria on my crystal report.
Report is binded to a data view.
and i m doing like this

  CRViewer.SelectionFormula = "{v_advances.creationDate} > '2/2/2004' "

v_advances= database view name
creationDate= view's field's alias name

and its not working.

kindly tell me; how to compare dates in selection formula of crystal report.

I am using visual basic.net 2003.
0
capriono
Asked:
capriono
1 Solution
 
viola123Commented:
hi, i think you'd better convert '2/2/2004'  to date field. do not use it as a string. cos i don't use VB.net, so not sure how to convert it to date in VB.NET. but in crystal report >'formula editor' , you can use this function 'Date(YYYY,MM,DD)' to do it. that is Date(2004,02,02)

viola
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now