Formatting Strings

[jatsingh]

hi, been an age since my programming days and looking for some help with this simple thing

i need to format a date entered by the user via a dialog box

user will enter 22-apr-2005 and need this formatted several times, into month (mmm), month (mmmm), previous month (mmm)

I then need to include the formatted values into a formula, help with referencing the formatted values would also be much appreciated.

Sorry if this is below your skills

 

[HarleyQuinn]

Have a look at Format() in the VBA help. That should point you in the right direction.

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[SkipVought]

Also...

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]