deq()

Read(201) Label: two date values, equal,

Description:

Compare the specified two dates.

Syntax:

deq(datetimeExp1,datetimeExp2)

Note:

The function compares two parameters - dateExp1 and dateExp2 - to see if they are equal.

Parameters:

datetimeExp1

Date or standard datetime format string

such as yyyy-MM-dd HH:mm:ss, yyyy-MM-dd, or HH:mm:ss

datetimeExp2

Date or standard datetime format string

such as yyyy-MM-dd HH:mm:ss, yyyy-MM-dd, or HH:mm:ss

Options:

@y

Accurate to the year

@q

Accurate to the quarter

@m

Accurate to the month

@t

Accurate to the ten-day period

@w

Accurate to the week

 

Accurate to the day by default

Return value:

A boolean value

Example:

deq("1988-12-08","1988-12-07")

false

deq@y(date("1988-11-08"),date("1988-09-12"))

true

deq@m(date("1988-11-08"),date("1988-09-12"))

false

deq@q(date("1988-12-08"),date("1988-10-12"))

true

deq@t(date("1988-10-08"),date("1988-10-12"))

false

deq@w(date("1988-10-05"),date("1988-10-08"))

true