Search results

I had tried criteria (ID#>640) for the date format which are different then what needed and applied Jon's query but still it is not giving me the appropriare result. Peter Can u please try this for me and attach the query Thanks Peter, Jigs

Yes Peter , you r true. Before I was handed over the project, the previous programmer had change the dataformat more then once and thats why it is creating problem ... But your suggestion is good to change the dataformat. The data which is in the demo database are data which is on my local...

I have original data available but that original data also consists of all the mash of date formats. I will not be able to delete any of the records in original data. The only thing I could do is change the data formats of all the data manually to dd/mm/yyyy. Is there any other way ? if yes...

When I tried to Convert whole field in DataType with Format DD/MM/YYYY, then it is mashing the format and does not help me. I tried. Peter Can u try this and help me please. Jigs :o

But Peter, Deleteing the records will not be possible for me as it consists of the old bookings data. Jigs :(

Hi, In the Production Version, I am going to use date format DD/MM/YYYY. The different date formats in the table was becuase the table already had some live data with MM/DD/YYYY date format and When I was handed over this project, the specification changed to DD/MM/YYYY. So in booking engine...

Here is the JigsDatabase.zip file which consists of 1 table bookings with required fields. Can u please have a look over it Peter. Jigs :)

Even gives the same error "Datatype Mismatch" in ColdFusion too. Jigs

It gives "Data Type Mismatch" error in MS-Access Yes, It gives "Data Type Mismatch" error in MS-Access Jigs :(

Data Type Mismatch Hi, Now it gives "Data Type Mismatch" error. :confused: Jigs

Hi, According to your suggestion, I had tried in MS-Access query as following : SELECT ACH_REF, CLIENTNAME, DATE, ARRIVAL_DATE FROM BOOKINGS WHERE (((DateSerial(Right([ARRIVAL_DATE],4),Mid([ARRIVAL_DATE],4,2),Left([ARRIVAL_DATE],2))) Between CDate([#12/06/2005#]) And CDate([#14/06/2005#])))...

Datatype mismatch Error Hi, the solution which u gave by the following query SELECT BOOKINGNO, CLIENTNAME, BOOKINGDATE, ARRIVAL_DATE FROM TRAVELS WHERE (DateSerial(Right([ARRIVAL_DATE],4),Mid([ARRIVAL_DATE],4,2),Left([ARRIVAL_DATE],2))) Between #ParseDateTime(DateVar1)# And...

Elaborated Query in ColdFusion ARRIVAL_DATE is the text field in which date is stored in DD/MM/YYYY format. Now from Coldfusion page, I am using the following query : <cfquery name="Get_Arrival" datasource="Resv"> SELECT BOOKINGNO, CLIENTNAME, BOOKINGDATE, ARRIVAL_DATE FROM TRAVELS...

Still doesn't work I tried DateSerial(Right([ARRIVAL_DATE],4),Mid([ARRIVAL_DATE],4,2),Left([ARRIVAL_DATE],2)) but still it doesn't work. :confused:

Consider DateVar1 and dateVar2 as two ColdFusion Date variables which consists of valid dates as FromDate and ToDate.

Hi All, I have a fields "ARRIVAL_DATE" in which arrival date is stored. This fields is text field in which date is stored in DD/MM/YYYY format. Now, I want to search by ARRIVAL_DATE which falls in between perticular date bounds using between but I am not able to do so. I am not getting the...

Hi All, I have 2 tables. [1] AvailableCars [2] CarPics [1] AvailableCars consists of fields as Zone (eg. ZoneA, ZoneB, ZoneC) , CarCategory (eg. CarAA1, CarAB1, CarAA2 ... and so on), DailyRates, and Valid DateBounds (FromDate, ToDate). [2] CarPics consists of CarCategory and Carpicture (Path...

Hi All, Can any one will be able to explain me "What is the key attribute in Data Modeling ?". :o Thanks in advance, Jigs

Hi All, I m using MS-access as backend and I am using the following query where I use FIRST() as aggregrate function. SELECT FIRST(COUNTRY) AS FIRSTOFCOUNTRY, ZONECODE FROM LOCATIONS GROUP BY COUNTRY,ZONECODE HAVING ZONECODE = "ZONE01" Now I have to shift my access database to SQL server...

Hi All, I have one table where ID field is autogenerated, and another field orderno which is not primary key. Now it has 2 duplicate values in it so when I try to make field Orderno as primary key, it is not allowing me to do so. Can any one help me how to find the duplicate values using...