Tagged questions

22 results found

alternative for CDate functionAugust 17, 2011

Hi experts out there. i use this statement startDate = CDate(rsDate("startDate") & " " & rsDate("startTime")) in db, i store it in datetime format startDate &#160

15

views

0

votes

2

answers

Crystal Reports 2008 Cdate problem Bad Date Format StringAugust 17, 2011

Hi guys, Hope you can help. I have a sub report to which parameters are passed from the main report. This involves  two formula fields startdate and enddate (date format)  two parameter fiel

17

views

0

votes

11

answers

Problem in Acces with CdateAugust 17, 2011

Hello: Here is the code which is a pop-up window to get the date, then it converts the date to a period: 1) Public Function MaxMes(fecha) As String 'max day of month Dim fech As Date Dim mes As Lo

12

views

0

votes

17

answers

Crystal Reports Month ValueAugust 17, 2011

I been asking a lot of questions today, thanks to all who replied. I'm coming across a problem trying to convert a number value to a date. The problem is when the month value is a two digit value.

16

views

0

votes

8

answers

CDate conversion errorAugust 17, 2011

Hi I have a textbox ticketDate.text which have value "21-10-2003". I used the CDate function to conversion it :-  CDate(ticketDate.Text) but have run time error.    Cast from

13

views

0

votes

12

answers

sql query syntaxAugust 17, 2011

Hi, We have an application that makes a selection from a Access database based on on date that is passed in. For example if we pass in 10/26/2006, it would select all items that match that month in a

17

views

0

votes

4

answers

System.InvalidCastException: Cast from string "11/18/2003" to type 'Date' is not valid.August 17, 2011

Why can't I format this: CDate("11/18/2003") in asp.net Do I have a culture set up somewhere different then un-us?

15

views

0

votes

4

answers

ASP Date ProblemAugust 17, 2011

Hi, I've got this ASP page that searches for records within a date range in a database When I enter to search dates 03/03/03 to 04/03/03 (in UK format dd/mm/yy) and search, it then displays the re

0

views

0

votes

7

answers

Too few parameters when building query in vb, which in turn uses a saved queryAugust 18, 2011

When I create a recordset in vb, it's usually looks something like:     Set qdfKeyWord = db.QueryDefs("qryPCKeyWord ")     For Each prm In qdfKeyWord.Parameters &#160

12

views

0

votes

7

answers

SQL CDate ConversionOctober 14, 2016

Good Morning. I have a CDATE function in a MS Access query, which I am attempting to emulate in SQL Server. This is only my second time to create a query in SQL Server, so I'm a little green. I hop

227

views

0

votes

0

answers