Field Criteria general date plus 30 minutes

[Accessor]

I'm trying get a criteria for a date plus 30 minutes.

 

[dbDamo]

= dateadd("n",30,now())

Just an idea

 

[Galaxiom]

= Now() + 30/(24*60)

Dates are recorded as numbers of days with times as parts of a day.

 

[dbDamo]

Both work though...

 

[gemma-the-husky]

bear in mind that time in its own is only 24 hours

so 23:45 plus 30 mins is 00:15, which is earlier than 23:45

ie it loses the extra day carried over.

--------
which is why its tricky summing a series of times

 

[dbDamo]

Now() is a date and time function, so should be fine