I think these are what you want...
1. DATENAME('month',TODAY()) = July
1a) DATEPART('month',TODAY()) = 7
2) DATETRUNC('month',TODAY()) = 01/07/2015 00:00:00
2a) DATE(DATETRUNC('month',TODAY())) = 01/07/2015
Source: Date Functions
Thanks for u r quick reply...
I want to know the starting date of the month(i.e, Current month is July Starting date of the month is 01st July 2015) .
my concern is i want to calculate the weeks that is from month starting date on wards....
1st july 2015 is the date .
Month Startd date is 01
Week No 1(ie. 01 july 2015 to 4th july 2015)
week no 2(i.e, 05 july 2015 to 11th july 2015
like i want to calculate the week till last date of the month...
Thanks in advance.....
Thanks & Warm regards,