help pulling data for 1st or 15th every month ???

[tonygr]

Hi All,
I am using crxi11 developer, sql2000 server.
I am having trouble pulling all data for the 1st of every month or 15th of every month, ignoring month and year.

The date field is held in datetime type,

any help greatly appreciated.

tonygr

 

[Madawc]

DatePart ("d", {date1}) will give you the day of the month. Put it in a formula field, if the formula field were called @DayOfMonth then you'd test @DayOfMonth in [1, 15]

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[tonygr]

Thanks Madawc,

Works a treat

Regards
Tonygr