Weeknumbers from date

[Former Member]

Post Author: Jerome!

CA Forum: Formula

Hello,I've been editing some crystal reports. I would like to abstract the weeknumber (Dutch standard, weeks counting from monday) from a certain date from a database field. We're using quite an old version of modifying crystal reports 6.0. Does a command like PrintDate exist for a weeknumber in a report?Thank you in advance

[Former Member]

Post Author: Charliy

CA Forum: Formula

Check out the Help on the DATEPART function. It will give you a week number and allows you to specify what day the week starts on. You may have to do some other calculations to get your standard week number. Dig though the next few pages on this board and you'll find a few threads on this subject.