Is it possible to convert a date format ("yyyymmdd") to ("mm/dd/yy")?
Thank you in advance
Thank you in advance
-
-
Re: Date Format
On 27 Oct 2005 09:12:31 -0700, FlexCrush wrote:
[color=blue]
> Is it possible to convert a date format ("yyyymmdd") to ("mm/dd/yy")?
>
> Thank you in advance[/color]
Sure, if the field is a Date Datatype.
Simply set the Format property of the control to:
mm/dd/yy
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
-
Re: Date Format
Assuming you are converting a text string ("MyText") to a DateTime
("MyDate") you could:
MyDate = CDate(Mid$([MyText],5,2) & "/" & Mid$([MyText],7,2) & "/" &
Mid$([MyText],1,4))
King Ron of Chi
FlexCrush wrote:[color=blue]
> Is it possible to convert a date format ("yyyymmdd") to ("mm/dd/yy")?
>
> Thank you in advance[/color]
Comment
-
Re: Date Format
It worked perfectly. You are the "King"!!!!
Comment
Comment