Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Ads  
 


  Sponsors  

Meet Our Sponsors

OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  Default Value = 1 week from today
Previous Previous
 
Next Next
New Post 3/31/2008 1:58 PM
User is offline Mike Riley
245 posts
9th Ranked


Default Value = 1 week from today 

I'm trying to create a field (DateTime) whose default value is 7 days from today.  I've tried [DateTime:Now]+7, but get an error when I try to add a record.

Can anyone offer some suggestions?
 
New Post 9/24/2008 2:45 AM
User is offline dolfic
1 posts
10th Ranked


Re: Default Value = 1 week from today 

 Mike Riley wrote
 

I'm trying to create a field (DateTime) whose default value is 7 days from today.  I've tried [DateTime:Now]+7, but get an error when I try to add a record.

Can anyone offer some suggestions?

 

same problem !
 
New Post 9/24/2008 10:09 AM
User is offline Sebastian Leupold
15057 posts
www.deutschnetnuke.de
1st Ranked












Re: Default Value = 1 week from today 

you need to convert to ticks for calculations using appropriate Tokens and hidden field (myField_UDT_Ticks)

Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 9/24/2008 3:21 PM
User is offline Stefan Cullmann
1553 posts
5th Ranked








Re: Default Value = 1 week from today 

 Sebastian, the request is a bit more difficult.

Ticks are working perfect for filtering, but that request is about default values.

UDT supports TokenReplace for default values, but no expressions like in Calculated columns or for filtering. Even if expressions would be supported here, the default value needs to be a date (or a correct localized string) again.

I think the correct answer is: Sorry, it is not possible.

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
Form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to Form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport
 
New Post 9/24/2008 3:26 PM
User is offline Sebastian Leupold
15057 posts
www.deutschnetnuke.de
1st Ranked












Re: Default Value = 1 week from today 

oops, stefan is correct. but you might use a default value of now and a calculated column for next week

Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  Default Value = 1 week from today
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DotNetNuke Web Hosting w/ ASP.NET 3.5
Unlimited email boxes, Unlimited databases, Unlimited domains. Plans start at $4.97
www.MyWinHosting.com 		SteadyRain
Founded in 1999, SteadyRain has extensive experience delivering Internet technology strategies and solutions for a diverse client base, ranging from Fortune 500 firms to successful start-ups.
www.steadyrain.com 		AfterImage Internet Consulting and SEO Services
AfterImage provides search engine optimization (SEO), Internet consulting and hosting services for the Windows platform (IIS, ASP, SQL Server).
www.afterimage.nl/

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP