Hello all. I've searched for the better part of a couple of hours to try and capture just the current date WITHOUT the time to make a comparison with. right now I have a variable as a date equal to now(), i've tried to cast it for just the date in a variety of ways, but it always grabs the current time too, so in my sql statement it will never have a match. I've tried tostring(), i've tried date() i've tried now(date), i've tried many things that I know makes absolutely no sense just to get the date without the time. I know it's not that difficult of a task, but I'm finding this challenging.
my statement (for example) is "select datefield from table where datefield = '" & todaydate.tostring() todaydate is dim as date = now() and the datefield is datatype of nvarchar at this point. i had it as a datetime and smalldatetime and it would store the time in the field. I on ...
Go to the complete details ...