Expression-NOW() (insert current date and time into database)(VAD)

[pondsenth]

Hello

i do this follow example in ''https://www.3cx.com/community/threads/vad-expression-now.11819/'

but it will not work
i don't know what wrong

Ps. if insert CallNumber into database only this work but when i use Expression NOW() this not work

Thank you

 

[pondsenth]

Image

 

[edossantos]

Hi @pondsenth,

You should use the SQL command to get the current date. For example in SQL server it's getDate (), but that depends on your SQL engine. That way the database engine determines the current date.

Kind regards.