Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

default value for datetime

More
1 year 5 months ago #259144 by ritapas
Please help us help you and fill where relevant:
Your LimeSurvey version: 3
Own server or LimeSurvey hosting: own
Survey theme/template: n/a
==================
hello,
is there a way to set a default value for a date/time question?
If I put something like: '30.03.2024' (with or without quotes) I get this error:
Code:
CDbCommand ha riportato un errore nell'esecuzione della query SQL: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ''06.03.2024'' for column

thank you

 

Please Log in to join the conversation.

More
1 year 5 months ago #259435 by DenisChenu
SQL type : YYYY-MM-DD[ HH:ii:ss]

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member. - Professional support - Plugins, theme and development .
I don't answer to private message.
The following user(s) said Thank You: ritapas

Please Log in to join the conversation.

More
1 year 5 months ago #259446 by ritapas
Replied by ritapas on topic default value for datetime
Hello,
this is great. I thought I had to use quotes.
Thank you
Rita

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose