I am looking for a way to search a date field looking for the same day of the year across several years of data. Would appreciate any tips on how I might do this.
Compare date patterns that don’t include the year. For example, if you had a database with a Birthday field, and you wanted to select everyone who was celebrating their birthday today, you could use
Select datepattern(Birthday,"MM/DD") = datepattern(today(),"MM/DD")
1 Like
Thank you Dave for the quick response. PanX is quite magical in the hands of one so clever.