Dohhh. Many thanks for your help. I couldn't see the wood for the trees obviously.

A really useful function.

ALTER FUNCTION [dbo].[fnDateFormat] (@Datetime DATETIME, @Format VARCHAR(32))

RETURNS VARCHAR(32)

AS

BEGIN

DECLARE @DateValue VARCHAR(32)

SET @DateValue = @Format

...

I thought it might be something to do with the version of SQL Server I am using (2000) so tried it on 2008R2 and get the same result.

I'm not too...

Thanks for the prompt reply. The issue I get is as follows:

select [dbo].[fnDateFormat](getdate()-3,'dd/mm/yyyy')

-- today is the 11th so the minus 3 is to get a date in...

A very good function however it seems to miss the leading zero off dates that are in the first 9 days of the month when using a format of 'dd/mm/yy'...

I think the comparison operators in the example above were the wrong way round. I have used the following against a date column in a test system of mine...

Many thanks for all the answers here particularly the ones from Jeff and Karthik. They enable me to get rid of a lot of CASE statements! 🙂

Mmmm.

Now this may sound like a stupid question to some of the "guru's" on this forum. Why is there a need for a master table and a separate...

This is an interesting...

I always add columns to a table that records the date and time a record was created and by whom. I also have columns to show when records were...

Thanks for this. i have downloaded your example database and apart from a few errors on built in functions for some reason I have got it working on the...