What Sean says.

It'll be much easier to suggest which to use if you can give us some sample data and tell us what you want to do with it.

That really depends on what you're trying to achieve. Both could be correct (or incorrect).

Hide

Which answer are you getting the error on?

SELECT

SampleDate,

CAST(SampleDate AS time),

SampleID

FROM

DateTimeQuery

WHERE

CAST(SampleDate AS time) >= dateadd(hh, datediff(hh, 0, getdate()) - 1, 0)

AND

CAST(SampleDate AS time) < dateadd(hh, datediff(hh, 0, getdate()), 0)

That will return the data...

Ed Wagner (9/22/2014)

TomThomson (9/22/2014)

GilaMonster (9/22/2014)

Koen Verbeeck (9/22/2014)

Iek, now that...

There's a function called InstRev that might do it. I've never used Access in my life though so I can't be more helpful than that I'm afraid.

There would have to be some kind of memorial service.

I'd love to be a fly on the wall for the conversation when somebody explained that it wasn't backed up...

If you can create and alter tables then you're halfway there. You'll need to do both to get this done. The most important thing you need to do...

declare @String as varchar(20) = 'Rambla, Tony G.'

select left(@string,len(@string)+1-charindex(' ',reverse(@string)))

I was worried my membership had been revoked and there was something somebody wasn't telling me!

Hi Tuan,

welcome to the forums. What you're asking to do is theoretically straightforward but there are a couple of traps for the unwary. The principal difficulty is the...

As much as I...

Greg Edwards-268690 (9/17/2014)

Sean Lange (9/17/2014)

Greg Edwards-268690 (9/17/2014)

Anyone have some good rub / sauce recipes?

Looking at trying to mix my own.

Although I tend to like more heat than my wife and...

I'm like a little kid waiting for my new smoker. Unfortunately, I'm on a course for the week after it arrives so I'll have to wait before I get...