Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
a_f:f:af:month_difference2 [2022/09/02 02:51] – removed - external edit (Unknown date) 127.0.0.1a_f:f:af:month_difference2 [2023/05/09 01:11] (current) – sean
Line 1: Line 1:
 +{{tag>Index Function Function_List Date_And_Time}}
 +====== MONTH_DIFFERENCE2 ====== 
 +===== Description =====
 +Calculates the month difference between the first date and the second date ignoring years. \\ For example:
 +
 +''MONTH_DIFFERENCE2'' (15/06/1985, 17/07/1998) = 1 \\ (the difference between June and July is 1)
 +
 +''MONTH_DIFFERENCE2'' (15/06/1985, 14/05/1973) = 11\\ (the difference between June and May is 11)\\ 
 +
 +The function can be useful, for example, when determining next anniversary of some event.
 +===== Parameters =====  
 +Two attributes of the Date type or date constants or calculations producing a date
 +===== Example =====  
 +<code aim>IF MONTH_DIFFERENCE2 (CURRENT_DATE, Client.DateOfBirth) = 3 THEN 
 +   SEND ReminderEmail TO Client </code>