Display ans select a string field as a date with the lookup ?

[MikeR]

I have an external SQL database that I am displaying updating on a netwebform.
The field date1 is defined in the sql table as a string field (varchar) .
It actually contains a date in the format yyyy-mm-dd
I am happy to display it as such but would like the functionality to edit is and have a calendar lookup for it on the form.
also I have to store it back in the database as a string yyyy-mm-dd ?
How can I accomplish this ?

[Bruce]

well I guess one useful tip is that
yyyy-mm-dd
is
@D10-

That may come in handy somewhere - but I'd have to experiment a bit to see what is involved in storing the date (formatted) in a string field.

[MikeR]

Thanks Bruce, look forward to your response, changing the field to date in netwebform obviously doesn't work ?

[Bruce]

Hi Mike,

I've added an option to NT 7.07 called

Date Lookup Picture

so now when you add a date field to a form, you can specify the picture and the Date Lookup picture separately.

In your case you'd set the Picture to '@s10' and the DateLookup Picture to '@D10-'

For existing apps nothing changes. If the Date Lookup Picture is blank then the Picture is used instead. If the Picture field is blank then the p_web.site.DatePicture picture is used.

cheers
Bruce