Insert date and day in field

I need to insert dates and day in filed for current whole month like: (VB6 code)

01-01-2012 Sun
02-01-2012 Mon
03-01-2012 Tue
.
.
31-01-2012 Tue

Thanks

You have to give more info than that.

Insert into what for example.

Actually, it's very simple... make the field a Date or DateTime field (depending on the DB being used) ... and simply insert it using parameters and standard SQL.
more info in the Database FAQ and Tutorial trhead.

-tg

Hello kafsar,

Since it would appear that you are asking a Database related question, for now, I am going to move your thread to the Database Development Forum which is where you should get the most help with your question.

Let me know if you have any concerns with me doing this.

Thanks for the report tg :thumb:

Gary