We need to calculate Date Difference in Months, and are using "DateDiff".
Between March 1st 2005 to March 1st 2015 there are 10 years = 120 months. However ETL is returning 119 months, please suggest how to get the correct value.
At the moment it returns the approximate number of months between two specified Dates
The approximation based on an assumption of 30.4375 days per month. Fractional months are not counted. Thus, for example it reports the difference between February 1 and March 1 as 0.
To make it work the way you want we would meed to modify our software.
+ Google spreadsheet API update
+ Support for Salesforce Bulk API was introduced
+ Added MONTH_EXACT to DateDiffS function
+ Zip libraries update
+ Added Search in subdirectories Option to File Operation, Check File and Archive Actions
+ All code related to execution packages was removed from the agent
+ Agent is used for scheduling only now
+ All packages are executed by aetlcl.exe
We have upgraded to 5.8.1.0 and still the date diff in months is returning 119 months between the two above dates,please suggest alternate method for this to work right
