Thanks guys. I used Wayne's solution and it worked fine.

No formatting options whatsoever I'm afraid. All data is also left justified automatically which is not very nice for numerics. Nothing I can do about that.

I do have...

Thanks Bob - that's great!

That's a lot neater than a string conversion.

Many thanks.

Hmmm. I've looked at the documentation on that. It could be a possibility but I'll have to think about it

Thanks for the quick response. I took a look at this sysservers table and I don't think this solution will help because all four database environments are on the...

Thanks - that works a treat now. I will bear in mind your comments about the temporary table. 🙂

Thanks for the suggestion. I tried the code and got an error:

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless...

Hi Jeff,

Yes, your algorithm is indeed correct.  I never really doubted that ... I always suspected it was a db data issue.

With help from Sergiy the date conversion allowed me...

Hi Sergiy,

Thanks for the code.  That has now shed some light on the matter.  With the start and end dates reset to 1st May and 31st May respectively, when I...

Hi Sergiy,

Not sure how to do this ... also, not sure of the value of doing this - what would it tell me?  The examples in my post are clearly...

Hi Jeff,

The database table I am interrogating is called Object which includes fields called StartDATE and EndDATE which are both of data type Float 8.  The table has only one...

Hi,

It looks great at first, but for some reason I have a strange problem when using it.

I have a start date of Wed 1st May 2002 and an end date...