Hi...

Try use =TODAY() for the date, and =NOW() for the time...

If =NOW() return no result, try a different format for =TODAY() formula.

Hope it helps...

Marcos.