sourceforge.net logo

Date & Time

Current Time

time()

Day of Month

day([Date])

Arguments. 

  • Date: a date (optional)

Day of Week

weekday([Date][, Week begins on Sunday])

Arguments. 

  • Date: a date (optional)

  • Week begins on Sunday: a boolean (0 or 1) (optional)

Day of Year

yearday([Date])

Arguments. 

  • Date: a date (optional)

Days between two dates

days(First Date, Second Date[, Day Counting Basis][, Financial function mode])

Returns the number of days between two dates.

Basis is the type of day counting you want to use: 0: US 30/360, 1: real days (default), 2: real days/360, 3: real days/365 or 4: European 30/360.

Arguments. 

  • First Date: a date

  • Second Date: a date

  • Day Counting Basis: an integer >= 0 and <= 4 (optional)

  • Financial function mode: a boolean (0 or 1) (optional)

Month

month([Date])

Arguments. 

  • Date: a date (optional)

Week of Year

week([Date][, Week begins on Sunday])

Arguments. 

  • Date: a date (optional)

  • Week begins on Sunday: a boolean (0 or 1) (optional)

Year

year([Date])

Arguments. 

  • Date: a date (optional)

Years between two dates

yearfrac(First Date, Second Date[, Day Counting Basis][, Financial function mode])

Returns the number of years (fractional) between two dates.

Basis is the type of day counting you want to use: 0: US 30/360, 1: real days (default), 2: real days/360, 3: real days/365 or 4: European 30/360.

Arguments. 

  • First Date: a date

  • Second Date: a date

  • Day Counting Basis: an integer >= 0 and <= 4 (optional)

  • Financial function mode: a boolean (0 or 1) (optional)