Module DateExt

Index

Functions

Functions

UTC

UTC(date?: string | number): Date

- Defined in ql/time/date.ts:63
parse data string to UTC date

Parameters
- Default value date: string | number = undefined
Returns Date

add

add(d: Date, n: Day): Date

- Defined in ql/time/date.ts:149
Parameters
- d: Date
- n: Day
Returns Date

addPeriod

addPeriod(d: Date, p: Period): Date

- Defined in ql/time/date.ts:543
Parameters
- d: Date
- p: Period
Returns Date

adda

adda(d: Date, n: Day): Date

- Defined in ql/time/date.ts:159
Parameters
- d: Date
- n: Day
Returns Date

advance

advance(date: Date, n: Integer, unites: TimeUnit): Date

- Defined in ql/time/date.ts:329
return new date, does not modify input date

Parameters
- date: Date
- n: Integer
- unites: TimeUnit
Returns Date

checkSerialNumber

checkSerialNumber(serialNumber: number): void

- Defined in ql/time/date.ts:304
Parameters
- serialNumber: number
Returns void

dateTime

dateTime(d: Date): number

- Defined in ql/time/date.ts:144
Parameters
- d: Date
Returns number

day

day(d: Date): Day

- Defined in ql/time/date.ts:103
Parameters
- d: Date
Returns Day

dayOfMonth

dayOfMonth(d: Date): number

- Defined in ql/time/date.ts:87
Parameters
- d: Date
Returns number

dayOfYear

dayOfYear(d: Date): Day

- Defined in ql/time/date.ts:95
https://stackoverflow.com/questions/8619879/ javascript-calculate-the-day-of-the-year-1-366

Parameters
- d: Date
Returns Day

daysBetween

daysBetween(d1: Date, d2: Date): number

- Defined in ql/time/date.ts:526
days between 2 date

Parameters
- d1: Date
  
  Date
- d2: Date
  
  Date
Returns number

Integer

should have not allowed to pass null to date value need to use QL_NULL_DATE instead

endOfMonth

endOfMonth(d: Date): Date

- Defined in ql/time/date.ts:248
Parameters
- d: Date
Returns Date

equal

equal(d1: Date, d2: Date): boolean

- Defined in ql/time/date.ts:168
Parameters
- d1: Date
- d2: Date
Returns boolean

fractionOfDay

fractionOfDay(d: Date): number

- Defined in ql/time/date.ts:136
Parameters
- d: Date
Returns number

fractionOfSecond

fractionOfSecond(d: Date): number

- Defined in ql/time/date.ts:140
Parameters
- d: Date
Returns number

fromDate

fromDate(d: Date): Date

- Defined in ql/time/date.ts:508
Parameters
- d: Date
Returns Date

fromSerial

fromSerial(serial: number): Date

- Defined in ql/time/date.ts:484
https://stackoverflow.com/questions/16229494/ converting-excel-date-serial-number-to-date-using-javascript

Parameters
- serial: number
Returns Date

fromString

fromString(s: string): Date

- Defined in ql/time/date.ts:512
Parameters
- s: string
Returns Date

hours

hours(d: Date): Hour

- Defined in ql/time/date.ts:120
Parameters
- d: Date
Returns Hour

isEndOfMonth

isEndOfMonth(d: Date): boolean

- Defined in ql/time/date.ts:254
Parameters
- d: Date
Returns boolean

isLeap

isLeap(y: Year): boolean

- Defined in ql/time/date.ts:172
Parameters
- y: Year
Returns boolean

localDateTime

localDateTime(): Date

- Defined in ql/time/date.ts:278
Returns Date

max

max(d1: Date, d2: Date): Date

- Defined in ql/time/date.ts:75
Parameters
- d1: Date
- d2: Date
Returns Date

maxDate

maxDate(): Date

- Defined in ql/time/date.ts:318
Returns Date

maximumSerialNumber

maximumSerialNumber(): number

- Defined in ql/time/date.ts:300
Returns number

milliseconds

milliseconds(d: Date): Millisecond

- Defined in ql/time/date.ts:132
Parameters
- d: Date
Returns Millisecond

min

min(d1: Date, d2: Date): Date

- Defined in ql/time/date.ts:79
Parameters
- d1: Date
- d2: Date
Returns Date

minDate

minDate(): Date

- Defined in ql/time/date.ts:314
Returns Date

minimumSerialNumber

minimumSerialNumber(): number

- Defined in ql/time/date.ts:296
Returns number

minutes

minutes(d: Date): Minute

- Defined in ql/time/date.ts:124
Parameters
- d: Date
Returns Minute

month

month(d: Date): Month

- Defined in ql/time/date.ts:107
Parameters
- d: Date
Returns Month

monthLength

monthLength(m: Month, leapYear: boolean): Size

- Defined in ql/time/date.ts:382
Parameters
- m: Month
- leapYear: boolean
Returns Size

monthOffset

monthOffset(m: Month, leapYear: boolean): Size

- Defined in ql/time/date.ts:392
Parameters
- m: Month
- leapYear: boolean
Returns Size

nextWeekday

nextWeekday(d: Date, dayOfWeek: number): Date

- Defined in ql/time/date.ts:258
Parameters
- d: Date
- dayOfWeek: number
Returns Date

nthWeekday

nthWeekday(nth: number, dayOfWeek: number, m: Month, y: Year): Date

- Defined in ql/time/date.ts:264
Parameters
- nth: number
- dayOfWeek: number
- m: Month
- y: Year
Returns Date

seconds

seconds(d: Date): Second

- Defined in ql/time/date.ts:128
Parameters
- d: Date
Returns Second

serialNumber

serialNumber(d: Date): number

- Defined in ql/time/date.ts:115
Parameters
- d: Date
Returns number

sub

sub(d: Date, n: Day): Date

- Defined in ql/time/date.ts:155
Parameters
- d: Date
- n: Day
Returns Date

subPeriod

subPeriod(d: Date, p: Period): Date

- Defined in ql/time/date.ts:547
Parameters
- d: Date
- p: Period
Returns Date

suba

suba(d: Date, n: Day): Date

- Defined in ql/time/date.ts:164
Parameters
- d: Date
- n: Day
Returns Date

ticksPerSecond

ticksPerSecond(): number

- Defined in ql/time/date.ts:290
Returns number

time

time(): Time

- Defined in ql/time/date.ts:537
Returns Time

todaysDate

todaysDate(): Date

- Defined in ql/time/date.ts:322
Returns Date

universalDateTime

universalDateTime(): Date

- Defined in ql/time/date.ts:282
Returns Date

weekday

weekday(d: Date): Weekday

- Defined in ql/time/date.ts:83
Parameters
- d: Date
Returns Weekday

year

year(d: Date): Year

- Defined in ql/time/date.ts:111
Parameters
- d: Date
Returns Year

yearOffset

yearOffset(y: Year): Size

- Defined in ql/time/date.ts:408
Parameters
- y: Year
Returns Size