TAG | Date/Time
25
Sql Server: DateRanges() Function
No comments · Posted by Craig Buchanan in Functions, Programming, SQL Server
This user-defined function creates a table of date ranges. (more…)
24
Business Objects Enterprise: Create a Dynamic List of Date Ranges
4 Comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, SQL Server, Technique
Add a dynamic, date-range parameter to a report which includes the most recent 12 months, plus Crystal Reports’ Month-to-Date and Year-to-Date ranges.
Business Objects · Business View · Crystal Reports · Date/Time · Parameters · SQL Server
8
Crystal Reports: FirstMonday() Function
No comments · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Finds the the first Monday in the current month.
29
Crystal Reports: ElapsedTime() Function
1 Comment · Posted by Craig Buchanan in Crystal Reports, Functions, Programming
Converts a number of seconds into a string in the format of days.hours:minutes:seconds.
24
Crystal Reports: Named-Date-Range Parameters
9 Comments · Posted by Craig Buchanan in Crystal Reports
Often it’s useful to be able to use date ranges that are relative to the date the report was run, like ‘Month to Date’, when running a report. While Crystal Reports’ parameters do not possess this level of flexibility, it is fairly simple to approximate this capability. This approach uses two parameters and Crystal Reports’ date ranges to do so.
3
Considerations For Reporting Against Remedy ARS Based Applications
6 Comments · Posted by Craig Buchanan in Crystal Reports, Remedy ARS
Applications built with the Remedy® Action Request System™ (ARS) client/server workflow engine are wonderful online transaction processing (OLTP) environments. When it comes to getting meaningful information back out of ARS environments, the users and application designers get a bit befuddled on what is available to them; what’s right for their organization.
Access · Crystal Reports · Date/Time · Remedy ARS · Timezone
17
Cogniza announces the release of UFLTimeZone for Crystal Reports.
No comments · Posted by Craig Buchanan in Business Objects Enterprise, Crystal Reports, Remedy ARS
For Immediate Release
Monday, June 17, 2002 – Cogniza announces the release of UFLTimeZone for Crystal Reports. UFLTimeZone for Crystal Reports provides date and time zone conversion functions that give new options when using Crystal Reports with Remedy’s Action Request (AR) System. To understand the value of this new product, some background on Remedy is appropriate.
Business Objects · Crystal Reports · Date/Time · Remedy ARS · Timezone · UFL
