SAP Data Services Date_Diff Function

The Data Services date_diff function compares date1 and date2

 Originally date1 was the later date (end date) and date2 was earlier (start date). As of Data Services 4.2.2 (14.2.2) the first date is the earlier date and date2 was later



SAP Data Services Date_Diff Function error problem in BODS 4.2 

 

Prior to Data Services 14.2.2 the date_diff function works as below:

 

date_diff(end_date, start_date)

 

After Data Services 14.2.2 the date_diff function works like this:

 

date_diff(start_date, _end_date)

This may bring SAP Data Services into line with other products but it really needs to be highlighted to customers as it will break any data services job using date_diff in a job after you upgrade to BODI BI 4.2 or SAP version 14.2.2 or higher

See P41 in the attached document from SAP

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_upgrade_en.pdf