accessing year and month part frm the entered date

[rekhasc]

hi......
Its very urgent......... ..... how can i take only the year and month part and it should save in the database in the month and year field separately..... .... when i enter the date in the form it should automatically update the year and month field in the db........ in my proj i am drawing a graph on daily, monthly and yearly basis..... i got how to draw a graph on day basis but i dont know how to draw a graph on month and year basis can any one help me plz.......... i am using vb6.0 and back end ms access........

[creative1]

Try this
IF you enter date in masked text box. It could be anywhere
d = StartingDate_ms k.Text
Dim m As String
Dim d As String
Dim y As String
m = (d)
d = Mid(d1, 1, 2)
y = Mid(d1, 4, 2)

it will extract day, month and year in variables. You can use them for validation checks or other processing

take care
Farhana

[rekhasc]

Try this
IF you enter date in masked text box. It could be anywhere
d = StartingDate_ms k.Text
Dim m As String
Dim d As String
Dim y As String
m = (d)
d = Mid(d1, 1, 2)
y = Mid(d1, 4, 2)

it will extract day, month and year in variables. You can use them for validation checks or other processing

take care
Farhana

i am using adodc1......... and when i enter the date in textbox it is storing in the database but i want to simultaneously store only month and year part in the database in different fields......... .............
in database the date format is medium date (1-jun-2007)

plz give me the code to do ths