Calendar lookup field blank

[johanco123]

Hi Bruce

I create a netwebform in Nt7.10 using an existing MSSQL database. In the field type I use 'Date' but the field is display a blank, even when I select a field from the lookup calender the field stays empty. When I change the field to a string the date display correct as a @d6 field.

Any suggestions

Regards
Johan

[Bruce]

What is the field in the SQL database declared as?
what is the field in your dictionary declared as?

[johanco123]

SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

[johanco123]

Hi Bruce

Any suggestions regarding the calendar lookup.

SQL - int
Dictionary  - Long (@d6)

Tanks
Johan

[Bruce]

perhaps make a small example Johan, with TPS if possible.
I'm guessing you have a setting wrong somewhere.

Or even just a screen-shot of the form-field settings might help.

cheers
Bruce

[johanco123]

Hi Bruce

I update the netwebform in the settings tab, 'Picture' as '@d6' and the 'Date Lookup picture' to '@d6,@s10'

The date is showing now  the correct date and the calendar lookup is working.

Tanks
Johan