Extracting Month From date 1

[Mammoth]

What would be the formula for creating a formula field to extract only the month from a date field so I can use it to sort by.

 

[Guest_imported]

You have the function month() wich gives you the month of a date, this way: Month({your_date}).

Of course {your_date} is an example.

 

[kenhamady]

The Month() function returns a number 1-12.

sorting by this will be OK only if all the dates are in the same year. if not use the following formula:

year({field})*100 + Month({field})

This field can be sorted on, but shouldn't be displayed.


If you can use a group instead of sorting, there is an automatic option to group a date by week/month/quarter etc. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)