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  |  

$4.95 Windows Hosting at Webhost4life.com
  Ads  
 


  Sponsors  

Meet Our Sponsors

The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
 


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
15045 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
1551 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
15045 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.
 


DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com 		TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com 		DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk

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