Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mipsfuct

    Date Range Select Problem

    Cool, thanks a lot... These are my first reports; you gave me a few things to ponder reagrding the months/years, I will play around with this tonight. Thanks again!
  2. mipsfuct

    Date Range Select Problem

    Thanks KSKID, that seems to work nicely, you saved me another nights reading! Synapse - I had a problem with that one, (too many arguments)...seems to be the "-1". Maybe I copied it wrong? Many Thanks.
  3. mipsfuct

    Date Range Select Problem

    Version: Crystal 10 Database: SQL I currently have a report that uses: {Deal_Jacket.title_comp_pend} in cdatetime(year(currentdatetime),month(currentdatetime),day(currentdatetime-1),7,0,0) to cdatetime(year(currentdatetime),month(currentdatetime),day(currentdatetime),7,0,0) - In order to...
  4. mipsfuct

    Restrict time range from datetime selection

    Thanks Rosemaryl! Appreciate the advice on posting as well.... I basically finished with this for (Mon-Sun 7:00am-7:00am) if anyone should need this. ({your.datefield} in (currentdate - dayofweek(currentdate)-5) +time(07,00,00) to (currentdate - dayofweek(currentdate)+1)+ time(07,00,00))
  5. mipsfuct

    Restrict time range from datetime selection

    Hello, I have what appears a simple problem but I cannot seem to resolve it on my own. I have to generate productivity reports that limit the evaluation time from (Mon 7:00 AM) to (Sun 7:00 AM). I know how to get Mon - Sun : ({Deal_Jacket.Billing_Comp_Pend} in (currentdate -...

Part and Inventory Search

Back
Top