>Hi everybody,
>
>I am trying to translate the following VFP code to C#
>
>

>                        padr(substr(transform(date_time),1,len(transform(date_time))-3),20)+' '+;

>
>This is what I wrote so far and a bit confused about date format and getting rid of AM/PM part:
>
>

>
> sbResult.AppendFormat("{0,20}", row.Field<DateTime?>("date_time"));

>
>I am not sure how to specify that g format for the date time and how to get rid of AM/PM designator (as VFP code seems to be doing).
>
>Thanks in advance.

Amazing thing Google, if you think to try it........ http://www.dotnetperls.com/datetime-format