convert date to string format dd-mm-yyyy

[david]

Hi

I'd like to convert todays' date to a string - but the format of the string
should be dd-mm-yyyy - and not dependent on my system settings - Is there
an easy way to do it ???

David

[Phil Weber]

> I'd like to convert today's date to a string - but the format
> of the string should be dd-mm-yyyy - and not dependent on
> my system settings - Is there an easy way to do it ???

David: Look up the Format function in VB's online help.
---
Phil Weber

[Arthur Wood]

And specifically, the way to do it is :

MyDateString = Format$(MyDateField, <date format string>) ===>

MyDateString = Format$(MyDateField,"DD-MM-YYYY")


it is that easy. You can use ALMOST any date formatting that you may need,
totally independent of whatever you may have set for you regional settings
in the control-panel.

Arthur Wood

"Phil Weber" <pweberonline@fawcette.com> wrote:
> > I'd like to convert today's date to a string - but the format
> > of the string should be dd-mm-yyyy - and not dependent on
> > my system settings - Is there an easy way to do it ???
>
>David: Look up the Format function in VB's online help.
>---
>Phil Weber
>
>