Date

DateDiff()

Brian Element's picture
Submitted by Brian Element on Tue, 08/13/2013 - 08:30

Syntax: DateDiff(Interval as String, Date1 as Date, Date2 as Date, Optional DayOfWeek, Optional WeekOfYear) as Long

Parameters:

Interval - There are 10 different types of intervals.  Depending on the interval the DateDiff() well return the number of units in the Interval.  Below is a list of the 10 items.  In the script below I used constants to better define them.

Parameter

DateSerial()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:44

Syntax: DateSerial(Year as integer, Month as integer, Day as integer)

The DateSerial function creates a Date value from separate month, day, and year values.

DateValue()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:44

Syntax: DateValue(StringDate as String) as Date

The DateValue function assignes a specific data to a type Date variable.  Converting a string representation of a date into a Date value.

Parameters: The StringDate can be different date formats in string, the following are a few examples:

  • "January 10 2007"
  • "January 10" - defaults to current system year
  • "Jan 10 2007"
  • "10/Jan/2007"
  • "10/01/2007"
  • "10/Jan/2007 14:10:10" - won't return the time portion

Now()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:44

Returns the system date and time as a type Date.

Date()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Returns the system date (no time information).

Time()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Returns the current system time (no date information).

TimeValue()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Use the TimeValue function to create time values for type Date variables.

TimeSerial

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:43

Use the TimeSerial function to create time values for type Date variables.

For TimeSerial, the values are normally in the range 0 to 23 for hours, and 0 to 59 for minutes and seconds. Larger values wrap to the next larger unit; therefore, a seconds value of 90 corresponds to one minute and 30 seconds

Day()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:42

Syntax: Day(DateValue as Date) as integer

Day(date) Returns a value 1–31 representing the day of the month

Parameter: The DateValue must be a valid date.

Hour()

Brian Element's picture
Submitted by Brian Element on Sat, 07/14/2012 - 19:42

Hour(date) Returns a value 0–23 representing the hour of the day

Pages

Subscribe to RSS - Date