using and converting date and time values vbscript some Shortcuts you should know before beginning:
DateInterval:
yyyy for Year
q for Quarter
m for Month
y for Year
d for Day
w for Weekday
h for hour
n for Minute
s for second
but lets start with the functions:
now
returns the actual date and time
Example: wscript.echo now
Output: 10.12.2008 20:36:54 (tt.mm.yyyy hh:mm:ss)
date
the function date displays the actual date
Example: wscript.echo date
Output: 10.12.2008 (tt.mm.yyyy)
time
the function time displays the actual time
Example: wscript.echo time
Output: 20:26:08 (hh.mm.ss)
CDate
converts a date and time variable into the standard date and time format:
Example:
d="12,10,2008"
wscript.echo cdate(d)
Output:10.12.2008
isdate
used to test if a variable has a valid date format
Example:
d="12.10.2008"
if isdate(d) then
wscript.echo "date is valid"
end if
Output:date is valid
(the output of isdate(d) is -1 if the date is valid and 0 of not)
DateAdd
to add an value to an existing date
Syntax: Date(DateInterval,number,date)
Example: wscript.echo dateadd("m",1,"10.12.2008")
Output: 10.01.2009 (the function adds one month to the existing date)
datediff
displays the difference between 2 dates
Syntax: Datediff(DateInterval,date1,date2)
Example: wscript.echo datediff("m","10.12.2008","10.03.2009")
Output: 3 (10.03.2009 minus 3 month is 10.12.2008)
the Variable Interval is the same as in dateadd
datepart
returns a part of a date
Syntax:datepart(DateInterval, date)
Example: wscript.echo datepart("m","10.12.2008")
Output: 12 (displays the month of the date)
the Variable Interval is the same as in dateadd
dateserial(year,month,day)
used to calculate a specific date
Example:wscript.echo Dateserial(2009-1,12-2,22-11)
Output:11.10.2008
datevalue
used to format the date, if the year is left it uses the systemdate to complete an date:
Example: wscript.echo Datevalue("10-12")
Output: 10.12.2008
day
returns the day of an date (values between 1-31)
Example:wscript.echo day("10.12.2008")
Output:10
month
returns the month of an date (values between 1-12)
Example:wscript.echo month("10.12.2008")
Output:12
year
returns the year of an date
Example:wscript.echo year("10.12.2008")
Output:2008
monthname
returns the month of an date (values between January and December)
Example:wscript.echo monthname("8")
Output:August
hour
returns the hour of an time (values between 0-23)
Example:wscript.echo hour("20:24:00")
Output:20
minute
returns the minute of an time (values between 0-59)
Example:wscript.echo minute("20:24:00")
Output:24
second
returns the second of an time (values between 0-59)
Example:wscript.echo second("20:24:12")
Output:12
formatdatetime
Syntax: formatdatetime(date,format)
Example: wscript.echo formatdatetime(date,1)
Output: Mittwoch, 10. Dezember 2008 (long date format)
Example: wscript.echo formatdatetime(date,2)
Output: 10.12.2008 (short date format)
Example: wscript.echo formatdatetime(time,3)
Output: 20:30:34(displays a time using hh:mm:ss)
Example: wscript.echo formatdatetime(time,4)
Output: 20:30 (displays a time using hh:mm)
timer
returns the seconds since 0:00
Example: wscript.echo timer
Output: 44743,62 (Uhrzeit: 12:25.43)
TimeSerial
used to calculate a specific time
Example:wscript.echo timeserial(22-11,12-2,22-11)
Output:11:10:11
TimeValue
used to format the time
Example: wscript.echo timevalue("13:12")
Output: 13:12:00
Weekday
Example: wscript.echo (Weekday(Date))
Output: 2 (2=Monday)
1=Sunday; 2=Monday; 3=Tuesday; 4=Wednesday; 5= Thursday; 6=Friday; 7= Saturday
Weekdayname
converts the numeric Weekday into the Name:
Example: wscript.echo (Weekday(2))
Output: Monday
1=Sunday; 2=Monday; 3=Tuesday; 4=Wednesday; 5= Thursday; 6=Friday; 7= Saturday |
 |
Kommentare zu diesem Beitrag:
(Nr:7) AEmowlyHom schrieb am 13.08.2017 08:27
First things first, you should set a hard and fast target date because you'll completely quit, including two or three weeks from now. Core maca through the supplier energetix is definitely an herb that tests quite nicely for several males.
(Nr:6) Dennisnop schrieb am 24.02.2017 22:12
Zhheherhrh eg egemtr hrggwe wes egemtrghdfbsgd rwtwrqw
(Nr:5) Peruvian deep wave schrieb am 11.09.2016 08:37
I exploit the Peruvian deep wave https://www.youtube.com/watch?v=k1oaz7n0ILk as being a casual convey. I like how vogue they are really and how durable they are. I dont like how expensive they may be but i like the item. I love how they're high excellent and a certainly one of kind product or service.
(Nr:4) jlOk0OBem schrieb am 11.05.2014 17:41
Bavota I got to this page from your post about is_child() function .. I must tell you that this page is a life saver for me! I have a wsbtiee where I specifically wanted to know the page ID from the page slug as the content was referenced in an old excel file I had kept. The excel file had pageID and now the site has slugs .. this is going to save me a lot of time
(Nr:3) hrKumTFApwhX schrieb am 11.12.2011 02:04
Keep it cmoing, writers, this is good stuff.
(Nr:2) SOakPJWaqsyXu schrieb am 10.09.2011 12:54
+z$8frZdyL%68pSU/:>w<:E3.lG-!XIB
(Nr:1) h.ahrer schrieb am 30.10.2010 00:49
Endlich ein aufschlußreicher Beitrag zum Thema Date Time Functions.
Kommentare die nicht unmittelbar mit diesem Thema zu tun haben,
sowie Supportanfragen oder Hilfe bitte ins Forum posten: Support Forum
Kommentar abgeben: (kein lästiges anmelden, einfach posten!)
