PDA

Click to See Complete Forum and Search --> : Formatting dates


turfbult
Mar 5th, 2001, 12:52 PM
Hello,

Very simple question...

How do you format dates... eg. I just want to see dd/mm/yy.

myDate = now ???????????

Thanks
T

Mar 5th, 2001, 01:15 PM
MyDate = Format(Now, "dd/mm/yy")

Mar 5th, 2001, 01:18 PM
myDate = Format(Now, "mm/dd/yy")

turfbult
Mar 5th, 2001, 01:47 PM
Why does this not want to work - nothing is displayed!!

<%
dim date
date = now


%>
<html>

<head>
<title>test</title>
</head>

<body>

<p>the date is <%=date%> </p>
</body>
</html>

Mar 5th, 2001, 01:57 PM
Are you using this in an HTML or asp page?
To use script, you have to put it in asp and have IIS running on your pc.

I put your code in asp and it worked fine.

turfbult
Mar 5th, 2001, 02:00 PM
I'm a real idiot!!! Thanks.

turfbult
Mar 5th, 2001, 02:19 PM
Maybe I'm being stupid again, but I get this error.. if I just use mydate = now it works fine!!

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'Format'

new_page_3.asp, line 2

Here's my code

<%
myDate = Format(Now, "mm/dd/yy")

%>
<html>

<head>
<title>test</title>
</head>

<body>

<p>the date is <%=mydate%> </p>
</body>
</html>

CreoN
Mar 5th, 2001, 02:55 PM
Try using FormatDate instead of Format

turfbult
Mar 5th, 2001, 03:02 PM
Nope, get the same error....

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FormatDate'

Mar 5th, 2001, 03:12 PM
myDate = formatdatetime(now, 2)

The second param passed to formatdatetime is the format setting:

0 =Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed.


1 = Display a date using the long date format specified in your computer's regional settings.


2 = Display a date using the short date format specified in your computer's regional settings.


3 = Display a time using the time format specified in your computer's regional settings.

4 = Display a time using the 24-hour format (hh:mm).

turfbult
Mar 6th, 2001, 05:49 AM
Thanks Steve, this works great!!