Recent content by bloko

Thanks for that, works a treat

Hi, I am usuing a formula if (month({FutureDate}) = (month(currentdate) + 1)) and (year({FutureDate}) = year(currentdate)) then "Y" else "N" And this works for 11 months of the year but I remember last year this didnt work due to the year(currentdate) part of the formula and I never got...

I may have just found a way. I changed the date to text and added it to the item number in a formula and grouped the report by the formlua. Hopefully this is reliable.

I am after a report which count the number of items which have 2 of the same fields, eg date of delivery and item number, so I can see if any duplications are made. Any help will be much appreciated, I am using Crystal 11.

I am uploading a csv file to an SQL database, but its coming up with errors because the incident number, which is a primary key in the database, is used in more than one of the records. I only need to enter 1 of the incident numbers records to the database as it is used as count to produce a...

Thanks, much appreciated

Hi Simi, I have 1 table and I need to create a 2nd table with the 1st tables data. Thanks

I need help updating an old table data to a new table. the field sare the same for both tables shown below and the table names are SRW_Incident and SRW_Incident2. I have tried a couple of things but nothing seems to work. Any help would be appriciated. Thanks Incident_No int Unchecked (pk)...

Hi Guys, Still cant find the problem. I did find that instead of putting -1 in the date add part I can put -3 and it shows this months data. If i put -4, it errors, so I think it could be somthing to do with the days or months of the date. WHERE (Date = CONVERT(char(10), DATEADD(dd, - 3...

Jamfool - No I dont get an error gmmastros - Thanks for the info

I found 2 records which have blank statdeldte. Can blank date be causing the issue. p.s Thanks to everyone who is helping me, it is appreciated.

Hi Jamfool there are over 2000 rows, so will get searching and hope I find it near the top. I ran your query SELECT ISDATE([GRN Posted]) AS Expr1, [GRN Posted], ISDATE(StatDelDte) AS Expr2 FROM dbo.ZSPO AS invo WHERE (ISDATE([GRN Posted]) = 0) OR...

Hi Jamfool, I ran your code and it did run but threw up an error. Once i okayed it, it ran, I had a look through the data and it seems ok. The error message came up on record 18432, below is a section of the data. As for being nasty code, i can see why the guy left who wrote it as I am having...

Someone wrote the below code to run in SQL server 2005. For some strange reason after months of running fine it comes up with the error "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value" The sql code is needed to run a crystal report...

Fantastic, just what I was after. Thanks a lot