Crystal Reports Tools: Improve Performance While Saving Time and Money
  Resources  
Best sellers:
● cView
● Report Analyzer
● cViewSERVER
● ReCrystallize

Crystal Reports: Free trial
Articles:
● Administration
● Advanced
● Basic
● Crystal eNL
● Database
● Financial
● Problems Solved

 Books:
● CR Books
● Database Books
● Developer Books
Tools:
● All CR Tools
● CR Analyzers
● CR Bestsellers
● DataBase Tools
● CR Graphics
● International
● CR Mail UFLs
● ReCrystallizePro
● CR Schedulers
● CR UFLs
● CR Viewers

Add'l:
● About us
● Contact Us
● cViewSUITE Ppt
● Support

Crystal Reports
on Steroids

Crystal Reports: Calculating the Day Number in the Year

This useful function comes from Charliy Nash. This function can calculate the day number in the year. This can be useful in payroll or other date-based systems

Function (datevar tdate)
// DOY - Day of Year
// INPUT: Date to be evaluated
// OUTPUT: Julian day of the year
// Example: DOY(11–Feb-2003) = 42 (tdate - date(year(tdate),1,1))+1 ;

 

 

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.

These keywords may have brought you here: calculating day number in the year, crystal reports functions, crystal reports tutorials, crystal reports tips, crystal reports articles, crystal reports information, crystal reports tips, crystal reports help, crystal reports training.