>>The brain just refuses to yield on this one.
>>I need to calculate the number of Fridays (or any day) between 11/01/20 and 01/31/21.
>>The column the table in question - coindrop- is a datetime called dropdate.
>>I can determine that 815 rows happened on Friday during that time period.
>>The next question is - how may happened on the average Friday, for example?
>>Any ideas?
>
>Just spitballing off the top o'me head here:
>
>Select count(*) as FriCnt, DropDate from CoinDrop
>where DateName(dw, DropDate) = 'Friday'
>group by DropDate
>
>or summat as a start
Thanks, Dorris.
I'll try something like that
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.