Avatar of Graeme McGilvray
Graeme McGilvray
Flag for Australia

asked on 

Time/Date Query

Hi there, I am not sure if this is correct or not...

Set CheckCurrency=oConn.Execute("SELECT * FROM site_curr WHERE curr_update=<#"&Now()&"# AND curr_uptime=<#"&Time()+1&"#")

Open in new window

What I want to do is check if these values is more than 1 hour old from the values in the DB

eg if it is 10am, are the values prior to 9am (that same day)

Any help is appreciated

Avatar of undefined
Last Comment
Graeme McGilvray

8/22/2022 - Mon