Tagged questions

22 results found

vb.net error casting a "" to a date invalidAugust 16, 2011

What is wrong with this code? It is blowing up my application.  Some DOB in the database maybe NULL, some 01/01/2004 and some as 1/1/2004. CODE: Me.txtDOB.Text = CDate(RemoveNull(CardApp.I tem(&q

3

views

0

votes

4

answers

Using Cdate to create a recordsetAugust 16, 2011

I have an SQL DB, unfortunately I "cannot" change the field types all fields are nvarchar I need to create a record set. One of the fields called eventdate has a standard xx/xx/xxxx date val

5

views

0

votes

3

answers

Getting a date from a stringAugust 16, 2011

I have a field named Job_UserData_2 where users enter dates in text format. What I need to do is convert this string into a date, for which I used the following formula in a query: CDate(Left([Job_Use

18

views

0

votes

15

answers

Date formatting help!August 16, 2011

I have a stored procedure and in that stored procedure is a date/time formatted in the way of: 2000-03-20 00:00:00.000  and when i do a response.write on it it gives me 3/20/00 i want to be able

9

views

0

votes

5

answers

Internationalize?August 16, 2011

How can I Internationalize my app?  For example, when I do the following the result isn't correct for German users: If Now.Date > cDate("04/01/2004") Then  Return True Else

5

views

0

votes

12

answers

Time stamp calculations in different formats.August 16, 2011

I am downloading some information from a web site that is time stamped in this fashion datetime="20041214215926" First I need to subtract 3 hours from this timestamp and then caluclate how o

5

views

0

votes

5

answers

Date, Filename AND tab stampAugust 16, 2011

This is an extension to a previously asked question: [ http://www.experts-exchang e.com/Appl ications/C AD/ Q_22100 627.html ] The LISP below wor

22

views

0

votes

3

answers

Insert date in MySQL database...August 16, 2011

My problem is this: When I insert a date in a MySQL database, the formats are different. My insertion-code looks like this:   T = cStr(request.form("text"))   N = cStr(request.form

16

views

0

votes

10

answers

Crystal Reports CDate ErrorAugust 16, 2011

I am using Crystal 9.  I have the following formula: CDATE(mid({Military_calls. Code},6,2) +"/"+mid({ Military_c alls.Code} ,8,2)+"/"+ mid({Milit ary_calls. Code},10,2 )) The

0

views

0

votes

6

answers

CDate, Format IssueAugust 17, 2011

Column formatted as text in query-- yymmdd and want to: a) convert to date in the query without affecting the table. b) have it go from yymmdd to mm/dd/yy I know I should use CDate and Format, but can

4

views

0

votes

6

answers