{{tag>Function Function_List Date_And_Time}} ====== DATE ====== ===== Description ===== Returns the date constant built from the given numbers ===== Syntax ===== ''DATE (day, month, year)'' Can be used in the condition of a [[:ref:a_f:a:find|FIND]] action. ===== Parameters ===== An integer constant indicating day (1-31), an integer constant indicating month (1-12), an integer constant indicating year ===== Returns ===== **Date**: the date built from the given day, month and year ===== Example ===== IF DATE (DAY_OF_MONTH (Account.OpeningDate), 4, 2004) = 07/04/2004 THEN ... ===== Related ===== [[ref:a_f:f:af:day_of_month|DAY_OF_MONTH]], [[ref:a_f:f:af:month|MONTH]], [[ref:a_f:f:af:year|YEAR]], [[ref:a_f:f:af:timestamp|TIMESTAMP]]