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 |