Friday, February 10, 2012
  Search
Support Forum
Tracking Number
Last Post 15 Apr 2008 01:12 AM by Jason BAker. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Jason BAker
New Member
New Member
Send Private Message
Posts:2


--
12 Mar 2008 12:18 AM  

I am needing to set up a type of tracking number, is there a way to do this?  A example would be 0311081915  (mmddyyhhmm that the form was submited)?  I want this to be automatic.

I have version 1.05.04 for DNN 3.x


Jason

Sujay
Basic Member
Basic Member
Send Private Message
Posts:382


--
14 Mar 2008 01:33 PM  
Hi,

I will post a solution today.

Thanks & Regards,
Sujay
Jason BAker
New Member
New Member
Send Private Message
Posts:2


--
15 Apr 2008 01:12 AM  
Have you come up with the solution? 
Sujay
Basic Member
Basic Member
Send Private Message
Posts:382


--
15 Apr 2008 03:23 AM  
Hi,

You can use Field Query option of Textbox or Hidden Field(if you want hide it) ,
Use the following query which will output mmddyyhhmm format


select CASE len(datepart(mm,GetDATE())) when 1 then '0'+convert(varchar,datepart(mm,GetDATE())) else convert(varchar,datepart(mm,GetDATE())) end+
CASE len(datepart(dd,GetDATE())) when 1 then '0'+convert(varchar,datepart(dd,GetDATE())) else convert(varchar,datepart(dd,GetDATE())) end+
substring(convert(varchar,datepart(yy,GetDATE())),3,2)+
CASE len(datepart(hour,GetDATE())) when 1 then '0'+convert(varchar,datepart(hour,GetDATE())) else convert(varchar,datepart(hour,GetDATE())) end+
CASE len(datepart(minute,GetDATE())) when 1 then '0'+convert(varchar,datepart(minute,GetDATE())) else convert(varchar,datepart(minute,GetDATE())) end as TrackNumber

Thanks & Regards,
Sujay
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.