days creation based on one day in a month

[sakamsureshbabu]

Hi

i have one table like below

data	target
1/1/2014	30
2/1/2014	30
3/1/2014	30
4/1/2014	30
5/1/2014	30
6/1/2014	30

date format M/D/YYYY

but i want create some another field like

data	target	date1	target1
1/1/2014	30	1/1/2014	30/days in month
		1/2/2014	30/days in month
		1/3/2014	30/days in month
		1/4/2014	30/days in month
		1/5/2014	30/days in month
		1/6/2014	30/days in month
		1/7/2014	30/days in month
		1/8/2014	30/days in month
		1/9/2014	30/days in month
		1/10/2014	30/days in month

how can i create like this........

[sakamsureshbabu]

Hi Sasidhar

it is working Thank U......

[sasiparupudi1]

Hi

please close the thread if you got your answer

Thx

Sasi