Search results for query: *

I have a crystal report that I will be running using business objects on the 2nd and 17th of every month. I'm using sql commands in the crystal and need some help with a dynamic date query. Here's what I'm looking to do; if current day is between 1st day of month and 15th then capture date range...

Good point! thanks for your review!

I'm looking for some validation on my date range solution. I'm running a sql query in crystal reports as a command that is looking at the performance of an employee during their pay period(bi-weekly). I'm using business objects to automate the creation/sending of the report in excel format...

I'm looking for the number of times a record was viewed within a date range. Within the database I'm working with there is an action column where 16 = created and 32 = viewed and a logdate column. I am trying to capture a count of views within 2 days, 7 days, 15 days, 30 days, etc... of create...

I was on the vendors customer blog and found the sql, but when I put it in as a command. The duration repeats(for ex. user logs in twice for date range but shows four). When run in SQL management studio user comes up twice. SELECT u.username AS "User Name", b.logdate AS "Login Date", a.logdate...

Hello! I'm sitting here in cleveland looking at the sun, which I haven't seen in 6 months, trying to wrap my head around this DateDiff problem. What Im trying to say is that I'm checked out, but need to finish a project!:) I am looking to grab the difference in time of when a user logs in and...

Worked like a charm! Thank you very much!

I'm creating a report for the previous 13 months using the following formula, {dateended} > (CurrentDate - 395) and then setting the selection expert for the formula to IS TRUE. The end users want to see a visual of the date range in the header. Is there a way to use the existing formula or do I...