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

crystal report only showing today's records

I can now display the information of the database in a crystal report but now i need to select only those rows which date is equal to today's. how is it done?
0
memozebadua
Asked:
memozebadua
  • 2
2 Solutions
 
crgary_txCommented:
type in the below formula under report->selection formula->record
{table.datefield}=currentdate

Gary
0
 
mlmccCommented:
Looks good.

If your field is a DATETIME data then you need to check
Date({table.datefield}) = currentdate

mlmcc
0
 
mlmccCommented:
Glad i could help

mlmcc
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

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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