Date range fix 1

[gdangerfield]

I'm not that conversant in Crystal (Version 11). With that said, I created this report, and I want the labels to show all prescriptions to show that have a "soc" date within the past week from Saturday (Not Sunday). I don't know how to make queries for dates > mm-dd-yyyy. This is a SQL database I believe. I'd appreciate any help. Thanks


{LABELS.DISCYN} <> "*" and
{HR.PAT_STAT} in ["Active", "Pending"] and
not ({LABELS.RX_TYPE} in ["ANAPHYL", "ANCIL", "IVCATH", "TPN Cmpd"]) and
{HR.SOC} = WeekToDateFromSun

 

[kenhamady]

try changing the last line to this:

{HR.SOC} >= CurrentDate - dayofweek(CurrentDate)

This calculation always give you the prior Saturday.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[gdangerfield]

Thanks very much. That was perfect!! Thanks again, Gary