Having a blonde kinda day....
I have a field that is set to data type "smalldatetime" in a Microsoft SQL database. In the table, it displays the date in this format:
8/20/1999
When I pull it up in a query and display it on the web, it automatically displays in this format:
Aug 20 1999 12:00AM
My question is this -
I need to total dollars for each month. How can I pull the date, explode it, and check the month and year so that I can keep running totals of each? I have tried explode(" ",$date) and explode{"/";$date) and split. Any help would be appreciated!
8/20/1999
When I pull it up in a query and display it on the web, it automatically displays in this format:
Aug 20 1999 12:00AM
My question is this -
I need to total dollars for each month. How can I pull the date, explode it, and check the month and year so that I can keep running totals of each? I have tried explode(" ",$date) and explode{"/";$date) and split. Any help would be appreciated!
