Date Time default to current data time > DotNetNuke Module Product Forums > Data Springs Inc.

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

Data Springs Product Forums...

Unanswered Active Topics

Forums Search

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms

Subject: Date Time default to current data time

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

John
Posts:5

skipping stones

02/15/2008 12:09 PM
I am brand new to DNN and Dynamic Forms. I had a need to display on screen the current date and time for a new form that was being opened. I had discovered the "Advanced Field Options -> Default Value" field, but was having a problem getting my mind around what it needed to give me what I needed. Here is Chad's solution: Try setting up a hidden field... Actually make it a textbox field to make sure it's working first, or a textbox field that is read only and then once you get it working change it to a hidden field. Choose to use a SQL Default which is available only for textbox and hidden fields. Within this field try some SQL such as this: Select GetDate() As DefaultValue Also, if you later query the data I do believe there is already a form date/response time column in the DynamicForms_QuestionResponse table. For my purposes I did not need to hide the field, but the "read only" attribute was important. It is also true that there is a field in the database table which captures the date and time of the submit. I found that if I only wanted the date that the following would work as expected: Select CONVERT(VARCHAR,getdate(),101) As DefaultValue Finally, here's SQL code which you can run in Query Analyzer or SQL Server Management Studio to see the effect of your submit: SELECT DynamicQuestionResponseID, DynamicQuestionID, Response, UserID, SortOrder, InActive, ResponseDateTime, UniqueResponseID FROM dnn_DynamicForms_QuestionResponse WHERE (ResponseDateTime = (SELECT MAX(ResponseDateTime) AS Expr1 FROM dnn_DynamicForms_QuestionResponse AS dnn_DynamicForms_QuestionResponse_1)) Hope this helps someone else!

You are not authorized to post a reply.

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Date Time default to current data time

ActiveForums 3.7