ORACLE FUNCTION TO ACCESS CONVERTION FOR DATE.

[fernandezduk]

Hi all,

I have a function that states the following.

select
count
FROM
helpdesk
WHERE
STATUS IN (5, 4)
AND ASSIGNED_TO_GROUP_ IN ('HelpDeskEurope')
AND CREATE_TIME >=
((sysdate-to_date('01.01.70','dd.mm.rr'))*(60*60*24));

The date function converts a date to UTR date i.e. Number of seconds since 1970.

MY question is how do I convert this to Access PLEASE PLEASE PLEASE.

Thanks in advance.


Fingers Fernandez
Helping the world be a better place!!!
Have a nice day

 

[dhookom]

The number of seconds since 1/1/1970 is
DateDiff("s",#1/1/1970#,now())

Duane
MS Access MVP
Find out how to get great answers faq219-2884.