>>>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>
>So, is it:
>
>
>sbResult.AppendFormat("{0,20}", row.Field<DateTime?>("date_time").ToString("G"));
>
>But how to get rid of last AM/PM (BTW, not sure why VFP is removing it as the time will be ambiguous). Same thing of getting rid of last 3 chars?
It shows you sample output from the different formats. All you have to do is read ...