PC Review


Reply
Thread Tools Rate Thread

DateTime conversion in Field.Expression

 
 
Christopher Weaver
Guest
Posts: n/a
 
      28th Sep 2005
I've done this:

dtSortFields.Columns.Add("SelectionString");
dtSortFields.Columns["SelectionString"].DataType =
System.Type.GetType("System.String");
dtSortFields.Columns["SelectionString"].Expression = DisplayFieldsString;

And something like this in a loop that concatenates certain fields that I
want to display in a continuous string:

DisplayFieldsString= DisplayFieldsString+= FieldName + "+ ' ' + ";


Now I want to convert the fields of type DateTime or TimeStamp to a specific
format. So instead of DisplayFieldsString being a simple concatenation of
field names, I need to format those that contain date information.

Does anyone have any regular expression code that does this? Does anyone
know of any other means of doing this?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. M. Bruil Microsoft Access 2 26th Mar 2009 08:30 AM
Conversion of .NET DateTime to SQL datetime via VarBinary Karch Microsoft Dot NET 1 24th Mar 2007 02:30 PM
Conversion of .NET DateTime to SQL datetime via VarBinary Karch Microsoft ADO .NET 1 24th Mar 2007 02:30 PM
DateTime conversion to its sqlServer datetime float representation. A.Neves Microsoft C# .NET 1 20th Apr 2006 01:01 PM
XML dateTime conversion to DateTime.MinValue accross timezones Symon R Microsoft Dot NET 0 6th Aug 2003 07:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:55 AM.