• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 604
  • Last Modified:

In Crystal Reports XI how can I found the day of the year

I need to calculate the day of the year based on a parameters being passed in the Crystal Report.

Thanks, A
0
aakagi
Asked:
aakagi
  • 3
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
This should do:

DatePart(y, CurrentDate)
0
 
aakagiAuthor Commented:
I need to know the number of the day, like for January 11, 2010 that would be day 11 the year and for February 20, it would be day 51.  

Thanks, A
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes.. the one provided would do..

y inside DATEPART denotes Day of year (1 to 365 or 366 in a leap year)
And for your reference:

http://customerfx.com/pages/reporting/2009/11/19/working-with-the-datepart-function-in-crystal.aspx
0
 
aakagiAuthor Commented:
Oh, I got it....I thought that would only parse out the year....thanks so much worked great!!, A
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
And glad to help you out..
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now