DatePart to Extract Time...

[JJman]

I know this can't be that difficult, but I'm trying to put together syntax for the condition of a macro that fires if the current time is before 7:30 a.m. I know it would be something to the effect of &quot; if DatePart(hh;nn;ss, Now())< &quot; ... I hope this makes sense. Can anyone help with the syntax on this? Thanks!

 

[DougP]

try this

If Format(Now, &quot;hh:nn am/pm&quot = &quot;07:30 am&quot; Then
'do something here
End If


DougP, MCP

 

[JJman]

Works great. Thanks!