Hello NG,

how come that the format function does not work in Active-X-Script???

Format(date(),"ww")

What can I use instead of the format function???
Thanks for helping.

Daniela

what do you want to show.?

Do you really want FormatDateTime()

http://www.w3schools.com/vbscript/fu...atdatetime.asp

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Daniela Menneweger" <nospam (AT) hotmail (DOT) com> wrote

Hi Allan,

I want to show the week, or day of week, quarter,.... of a date. I didn't
find a way to get it back with another function.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:#EPrQAxvDHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl...

In article <#jHGVEyvDHA.2712 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Daniela Menneweger
<nospam (AT) hotmail (DOT) com> writes
Format is not a VBScript function, just VB.

VBScript does have other functions (as does VB), such as Weekday, Month
and similar.

http://msdn.microsoft.com/library/de...en-us/script56
/html/vtoriFunctions.asp


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org