Welcome to the LimeSurvey Community Forum

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

default value for datetime

  • ritapas
  • ritapas's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
4 weeks 2 days ago #259144 by ritapas
default value for datetime was created 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.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 weeks 4 days ago #259435 by DenisChenu
Replied by DenisChenu on topic default value for datetime
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 service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: ritapas

Please Log in to join the conversation.

  • ritapas
  • ritapas's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
3 weeks 3 days 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.

Lime-years ahead

Online-surveys for every purse and purpose