Hi Jagadeesh,

welcome to the forum. I'm not sure what your question is there. If you read the article in my signature it will make it much easier to...

Do you mean how do you show a rounded time in the end date column?

I looked at the question and thought that was a lot to do for first thing in the morning. Then I looked at it again and saw what the...

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...