Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RE: Converting a date

0 views
Skip to first unread message

Dale Fye

unread,
Jun 30, 2005, 4:44:03 PM6/30/05
to
Format(Date(), "YYYYMMDD")

Substitute your date field for Date().

HTH
Dale

"Dogwood" wrote:

> How do I convert a date from 6/28/2005 to 20050628?

Dogwood

unread,
Jun 30, 2005, 4:53:05 PM6/30/05
to
Thankyou

"Ofer" wrote:

> Try this
> Format([DateField],"yyyymmdd")

0 new messages