IsDummyZeroDate - Built-in Database Function¶

Purpose¶

Returns true when the passed value is considered a dummy zero date by the database driver.

Syntax¶

return IsDummyZeroDate(column)

Arguments¶

Returns¶

True when the value from the column is considered a dummy zero date

See also¶

• Next
• Previous
• SQL
• Sum

Examples¶

Used to color the value based on the dummy zero date status¶

if IsDummyZeroDate({Orders.DeliveryDate}) then
    return drRed
else
    return drBlack
end

Used as Suppress function¶

return IsDummyZeroDate({Orders.DeliveryDate})

Used in a filter function¶

return not IsDummyZeroDate({Orders.DeliveryDate})

Notes¶

• Each database driver has its own implementation for this function
• Do not compare the result of the function with true or false, use the not operand