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 Chris 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. R00k1e

    DateTime Issue

    Hi Ian, Yes, Crystal does show the field as a DateTime. BTW I am using Crystal 9.
  2. R00k1e

    DateTime Issue

    Hello, I have a View created in SQL Server that has a column with date information as a varchar. I did a Cast to that column to make it a DateTime. So in Crystal, that field displays as a DateTime but when I go to Select Expert and try to make it equal to my "DateTime" type parameter, it won't...
  3. R00k1e

    Data Formula Help

    Thank you everyone for the help. Works perfect now.
  4. R00k1e

    Data Formula Help

    Hi guys, I created my formula similar to what was previously suggested, but I am getting a formula error. It is saying I have too many arguments and the '6,30' was highlighted. Any suggestions? If month({paramDate})> 6 then Date(year({paramDate}+1, 6, 30)) else Date(year({paramDate}, 6, 30))
  5. R00k1e

    Data Formula Help

    Thank you for the feedback! I guess my issue is that I cannot hard code the end date. I need it so that when choose any date in any year, it will give me that date to the following June 30th.
  6. R00k1e

    Data Formula Help

    Hello, I'm currently using Crystal Reports 9 and need helping writing a formula. I have a parameter created with a value type of 'Date'. I need to create a formula that will give me the dates between whatever date is chosen from the parameter through June 30th. For instance, if I chose a date...

Part and Inventory Search

Back
Top