I am importing some information from a Word form's fields into a table in Access, but am having trouble with the DATE fields. The code below is only PART of the entire code; everything works/imports well, except that the date comes in as 12/29/1899 no matter what the Word document says for the date...

Dear Experts. I am using ASP.NET2.0, C#. I want to make Format mask. on a textbox that only Accepts Date format dd/mm/yyyy throught JavaScript. so please can you Help me.

I need to build a dropdown listing the week ending date in the text and the week number in the value from either the beginning of the year or a specified week number up to last week. I think I can work out all the week stuff but I can't get the last date of a given week. How do I get that? What I...

Expert: I never used MS project before and I have a copy of another MS (.mpp file) project which will be similar to mine. How do I go about changing the project plan start date to suit mine. The project is similar and I am trying not to reuse what I can. Addionally, how do you go about changing the task...

want to validate date in "dd/mm/yyyy" format ?

Hi: I have a table that has a timestamp column, ie. data in this column has a format of yyyy-MM-dd hh:mm: TimeStamp Revenue ------------- ----------- 2007-08-01 08:00 50 2007-08-01 08:10 38 2007-08-01 08:50 12 2007-08-01 09:00 34 ... 2007-08-10 23:50 90 In a query I need to group the data with the date...

Experts, IN SSIS I created a user variable to return the number of the month: Month( @[System::StartTime] ) If I need it padded, then I use (Thanks to the smart people at EE): Right("0" + (DT_STR, 2, 1252) Month( @[System::StartTime] ), 2) However I need to get the name of the month. I need...

The original question was: Is it possible to hand enter dates WITHOUT having ot use the separator? I've got an application where people need to hand enter lots of dates and this would make things a whole lot easier. They are using Excel 2003. For example I'd like them to be able to enter '12312006'...

Hello. I have an aspnet form which has a dropdown list and calender control. How do you validate the calender control so that when one selects a date older then today's date that a messagebox alerts the user. I tried custom validation control to no avail? Thanks Scott

My Table : Name ---- Birthday Date John ----- 01/JAN/1960 Mark ----- 02/Feb/1961 I wish my access query to show : Name ---- JAN---FEB---MAR JOHN ----- 01 ----------------- MARK -------------- 02 -------- My current SQL which cannot work : Select Name, month(Birthday)=1 as JAN, month(Birthday)=2 as FEB...