Recently a new client contacted me asking "How do I display my weekly report by week number?
Solution:
This is a relatively easy solution, one just needs to use Crystal Reports DatePart function:
DatePart( Interval Type, Fieldname, 1st Day of the Week, 1st Week of the Year)
To return the week number, for a company whose working day start on Monday:
DatePart( "ww", {Tablename.Fieldname}, crMonday)
If you have any questions, leave us a comment below, or need
any assistance, please do not hesitate to Contact
Us | 
