Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

aj3221 (TechnicalUser) (OP)
30 Jun 08 11:36
I have a report I run daily. I open it up, I click on Select Expert and change an "is equal to" parameter from the date there to the date I am running it. It's always today's date. For example, I open it up today and it has Friday's date. I type over that w/ today's date. Is there anyway to just have it pull "today's date" when I open it?
bdreed35 (Programmer)
30 Jun 08 11:55
From the Report menu, choose Selection Formulas, Record.
Alter your record selection formula to use this logic:

{table.datefield} = currentdate


Tatertot45 (TechnicalUser)
30 Jun 08 12:01
I'm not sure what version of Crystal you have, but there is an easy way in XI.  Open the record selection window and "Show Formual" and then go into the Formula editor.  Then your formula should have {table.Field}= (00,00,0000) or something.  change it to read:

{table.Field}= DateTime(CurrentDateTime)

If you have just a date field (no time), then

{table.Field}= Date(CurrentDate)

See if that works...
dgillz (Instructor)
30 Jun 08 12:43
Your problem is that you are using the very limited Select Expert, instead of using the record selection formula that was suggested by dbreed35.

There are tons of things you can do with a record selection formula that you cannot do with the select expert.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?"

aj3221 (TechnicalUser) (OP)
30 Jun 08 13:13
I went into Record Selection and put in my field then the = Date{CurrentDate} but got this box that says "A date-time is required here.". This field is a string and appears MM/DD/YY. Maybe I have to do something else first to the string? Convert it to a date?
bdreed35 (Programmer)
30 Jun 08 13:22
If it is a string on the database side, then you will need to convert the currentdate field to a string:

{} = ToText(currentdate,"MM/dd/yyyy")


aj3221 (TechnicalUser) (OP)
30 Jun 08 13:34
It says False on my report
bdreed35 (Programmer)
30 Jun 08 13:47
Where are you placing this formula?  It should be under Report|Selection Formulas|Record.


aj3221 (TechnicalUser) (OP)
30 Jun 08 14:13
that's where i am putting it  
aj3221 (TechnicalUser) (OP)
30 Jun 08 14:18
This is what I did: because me order date is a string I used your formula and created my own ORD DTE:
{ORDER_HEADER_A.ORDER_DATE} = ToText(currentdate,"MM/dd/yyyy")

Then I went into Report|Selection Formulas|Record and

{@ORD DTE} = currentdate

Now I get a boolean is required here when I tried to accept it
bdreed35 (Programmer)
30 Jun 08 14:37
You shouldn't be putting in it's own formula.
Just put this directly in the record selection formula:

{ORDER_HEADER_A.ORDER_DATE} = ToText(currentdate,"MM/dd/yyyy")  


aj3221 (TechnicalUser) (OP)
30 Jun 08 14:48
Genius! I was totally making that much harder than it was. Thank you so much! Sorry for being a pain!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close