Custom date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aneasiertomorrow - 19 Jun 2007 02:23 GMT

Hello all

I (all right, the graphic designer I'm working with - lord those people are
fussy!) would like to have the date format 19.06.07 rather than any of the
standard formats. I read on this wonderful forum that I need VBA to do that.
Can someone get me started/pointed in the right direction as I'm a bit
clueless. Just to give you all a laugh this is how far I've got:
Sub DateFormat()
Date.dd.MM.yy
End Sub
And it appears to do nothing, though at least it's happy with the syntax :-)
I tried adding quote marks but that was an invalid use of the property
apparently.

Please help and I promise I'll try harder to learn.

Lucy

Signature

MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too

Reply to this Message

Chirag - 19 Jun 2007 03:01 GMT

Where do you want this change to reflect? You can get this change
system-wide through Windows Control Panel, launch "Regional and Language
Options", click "Customize this format...", select "Date" tab, and type out
"d.M.yy" in "Short date" area, click OK. This should get you 19.06.07 date
format in PowerPoint as well.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

> Hello all
>
[quoted text clipped - 16 lines]
>
> Lucy

Reply to this Message

aneasiertomorrow - 19 Jun 2007 03:12 GMT

Fabulous thank you :-)

Is there a way to do it via VBA do you know? Just the client may not want to
change their system-wide settings and it's all about giving people choices...

Lucy

Signature

MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too

> Where do you want this change to reflect? You can get this change
> system-wide through Windows Control Panel, launch "Regional and Language
[quoted text clipped - 27 lines]
> >
> > Lucy

Reply to this Message

Chirag - 19 Jun 2007 03:30 GMT

In VBA, the following function will display the current date in the dd.MM.yy
format:
---
Sub MyDateFormat()
MsgBox Format(Now(), "dd.MM.yy")
End Sub
---

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

> Fabulous thank you :-)
>
[quoted text clipped - 40 lines]
>> >
>> > Lucy

Reply to this Message

aneasiertomorrow - 19 Jun 2007 04:31 GMT

Thank you so much :-)

Lucy

Signature

MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too

> In VBA, the following function will display the current date in the dd.MM.yy
> format:
[quoted text clipped - 53 lines]
> >> >
> >> > Lucy

Reply to this Message