Date Difference Function

[Ivan Smahin]

Hello Erne,


Erne wrote:
> Hello list,
> 
> I have a task but can't figure out how to accomplish it easily,
> maybe somebody has idea
> 
> I need to know how many days separate a recurrence (stored as  
> DateField) from today
> e.g.
> DateFormat is kMDY
> Separatore is /
> the recurrence is 01/03/1958
> and today is 12/03/2005
> 

I've read you message number times but I'm afraid I did not get it 
completelly.

Probably it would be better to see a couple of real examples?

01/03/1958	12/03/2005 	-	11 days

Right?

Anycase it seems you should consider usage of such set of SQL-functions:
Year
Month
Day

Just for simplifying your scripts (instead of continiously DatePart usage).


-- 
Best regards,
Ivan Smahin