FormatDateTime

[AndyApp]

People urgent problem,

When i use the "formatdatetime(date, 2)" instead of getting what every website on earth says i'll get "dd/mm/yyyy" i just get "dd/mm/yy". and if I use "formatdatetime(date,1)" instead of "monday, january 02, 2002" i just get "02 December 02"?

Can anyone tell me what's going on? "Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[onpnt]

FormatDate with the name arg. of 2 outputs only the 02 for the year. in order for you to get the full 2002 you need to do a little formatting.
take a look at this FAQ faq329-2091
it should help you in getting what you want My most satisfying and best work has come from helping others

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[onpnt]

after reading the FAQ I didn't make it very well detailed on what is going on there in reference to name of the month, year, or day. So I'm going to edit it to state that but for this try
DateToday = Month(date()) & "/" & Day(Date()) & "/" & Year(Date())

Month Day and Year will return the numeric value, and thus the
MonthName etc. returns the proper name.
My most satisfying and best work has come from helping others

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[spazman]

Check regional settings on the server.

 

[dilettante]

I think spazman nailed it.

Constant    Value  Description
vbShortDate   2    Display a date using the short date format
                   specified in your computer's regional settings.

Right out of the docs. Not sure where you got the idea you were guaranteed dd/mm/yyyy, perhaps just some examples that seemed consistent?

I recommend using the built-in named constants wherever they're available. Coding by "magic numbers" is considered bad form. This way somebody maintaining your code will have an idea what you were intending when you wrote it.