How do you remove the time from a date range formula? 2

[NewToThis2]

CR V9 I have the following formula in my report header:
ToText (Minimum ({PRTIME.PER_END_DATE})) + " To " + ToText (Maximum ({PRTIME.PER_END_DATE}))

which prints the result:
12/4/2004 12:00:00AM To 12/18/2004 12:00:00AM

I do not want the TIME printed in the result. I only want the DATES. Could someone possibly tell me how to modify my formula? Thanks!

 

[kskid]

Change it to

ToText (Minimum ({PRTIME.PER_END_DATE}),"MM/dd/yyyy") + " To " + ToText (Maximum ({PRTIME.PER_END_DATE}),"MM/dd/yyyy")


Cheers,

-LW

 

[oneilltnc]

You could also change it in the report settings, but this would convert all datetime fields on the report to just a date. Just go to File/Report Options and then change the Convert Date-Time field option to Date.

 

[NewToThis2]

Perfect! That's exactly what I wanted. Thanks so much! I wish there was a book or a web site with nothing but a listing of formulas. Thanks again!

 

[shelby55]

HI

Just an FYI, Ken Hamady (a frequent contributer to this forum) has his own website and has an entire page devoted to formulas. He also sells reference material with this info. Check out his website at

http://www.kenhamady.com/formula.html

Shelby

 

[NewToThis2]

Thanks for the info Shelby!