• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Date field in questionnaire
#1
Hi!

I have a multi-section questionnaire.

In the first section there's a 'Delivery Date' field to be introduced to the technician.
In the second section there's another field 'End Date'.

I would like this second field 'End Date' to appear automatically filled in according to the date entered previously in 'Delivery Date' + 3 days.

For example:
'Delivery Date': 13/05/2020
'End Date': 16/05/2020

Is this possible?

Thank you.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#2
(05-13-2020, 08:16 AM)pms23 Wrote: Hi!

I have a multi-section questionnaire.

In the first section there's a 'Delivery Date' field to be introduced to the technician.
In the second section there's another field 'End Date'.

I would like this second field 'End Date' to appear automatically filled in according to the date entered previously in 'Delivery Date' + 3 days.

For example:
'Delivery Date': 13/05/2020
'End Date': 16/05/2020

Is this possible?

Thank you.

Hello,
In your second section defined "Second date" :
Dynamique (SQL)

Field : dateadd(dd,3,RESULT_DATE)

Table : SD_QUESTION_RESULT

Join : LEFT OUTER JOIN SD_REQUEST on SD_REQUEST.REQUEST_ID = SD_QUESTION_RESULT.REQUEST_ID and SD_QUESTION_RESULT.QUESTION_ID=(select QUESTION_ID from SD_QUESTION where QUESTION_CODE = 'FIRST_DATE')

Where : SD_REQUEST.REQUEST_ID=@ID@

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)