CREATE FUNCTION dbo.fnGiorno360
(
	@Date1 INT,
	@Date2 INT
)
RETURNS INT
AS
BEGIN
	DECLARE	@Months INT,
		@Days INT,
		@dt1 DATETIME,
		@dt2 DATETIME

	IF @Date1 > @Date2
		SELECT	@Days = @Date1,
			@Date1 = @Date2,
			@Date2 = @Days

	SELECT	@dt1 = CAST(@Date1 AS VARCHAR),
		@dt2 = CAST(@Date2 AS VARCHAR),
		@Months = DATEDIFF(MONTH, @dt1, @dt2)

	IF @Months > 0
		SET @Months = @Months - 1

	SELECT	@Days = 30 - CASE WHEN DATEPART(DAY, @dt1) > 30 THEN 30 ELSE DATEPART(DAY, @dt1) END,
		@Days = @Days + CASE WHEN DATEPART(DAY, @dt2) > 30 THEN 30 ELSE DATEPART(DAY, @dt2) END

	RETURN	@Days + 30 * @Months
END

quote:

---

Originally posted by annamaria

[quote]Originally posted by Michael Valentine Jones

>> created to simplify manual calculations
Accountants have a complicated way of making things simple.

I wonder if you are talking about accountants in general or if you
are relating to the way I explained the 30/360 day count to Peter.
In fact I could have been clearer but hopefully he has managed to
solve the problem in spite of it.
I have another problem. This is the second time I post in the forum
and I've noticed that there are differences between the commands you use and the ones I use at the office.
I use QMF for Windows and, for examples, I don't think we use the carachter @. There also differences with ( ) and others.
I don't know if I will able to use Peter's function. Could you telle me how to translate your synthax into mine?

What's the meaning of CODO? And what's a PDA?
Hope to hear from you soon.
Anna from Verona (Italy)

---