Search results

Im not sure but im using Visual Studio to do my ASP, so im not sure what you mean by built in access functions? please advise?

i guess that worked just the same, thanks.

I have a field called productiondate and the data looks like this 2-1-2012 or 12-25-2011 and its a nvarchar(50) value type. i want to use substring and charindex to get the day month and year into seperate fields of day month year so far i can do this below and it gets me the month, but i...

Im doing a simple form of 21 fields that rights to a sql table. my issue is i cant get it to work unless i have all variables as strings and strings fields in my tables. here is my code and if i try to put in a field as integer or date it errors out. Im using VS 2008 my variables Dim...

i didnt realize there were other dates like that in the table. works now. thanks.

I removed the 32 records with the11/7/20111 but im still getting the same error

here it is in excel

yes i have a space after as. just didnt seem to copy over. i had 3 records where proddate was null, i put some data in there thinking that was it, but im still getting that error below. here is my field infor - PRODDATE (nvarchar(max), null) Msg 241, Level 16, State 1, Line 1 Conversion...

this is what i get for an error.... below is my query Msg 241, Level 16, State 1, Line 1 Conversion failed when converting datetime from character string. select vatnumber, tablenumber,galsofwater, proddate, HCVRecipe_name, watertemp, Cast(proddate as datetime) FROM VQ_PROD_TABLE_WATER

I have a field in a sql table called prodate but the field is a nvarchavr(max). data in this field comes in and looks like this 10/12/2011 or 2/15/2012, ect. how can i convert that to a datefield? i have tried cast(proddate, as datetime) i have tried using convert and nothing seems to work...

Thanks for the help guys.

both of those queries that i have in there have the same issue. the datesubmitted field is what im using

my database is too big to upload

bob neither of your suggestions work. i get errors about it being to complex?

even if i hardcode 4-1-11 and 4-30-11 in im still missing data from the 4-30 date.

it is a date/time field , but i have no times associated withthis field

I have a query and im using between [Start} and [end] for my criteria giving the user a parameter to enter the dates they choose. im using a field called datesubmitted and if anything is submitted on 1st of month or last day of month it wont pull into query. so if i put 4-1-11 and 4-30-11 as...

I have the following statment to determine age of employees, but when i run the query i just get data like 60,50,44, but i want it to be like 66.55,50.59,44.16 depending on how close they are to their birthday. (datediff(d,emp.brthdate,getdate())/365) as age,

i was able to find this, but it doesnt work when the first day of the month falls on a weekend. for this year January 1 is on a saturday thus it says its in week 5. when truly its a new month it should be a short week 1 day week. im guessing the week 5 comes from December 2010...

I want to find out a week number in a month in a query. for example this gives me the week number in a year datepart(wk,p1labdate) as week, but i would want to know somethign similar for a month for example for may 2011 and june 11. 5/1/11 would be week 1 5/8/11 would be week 2 5/15/11...