Calculed column with a strange behaivor

Hi everyone,


I hope that someone can help me.  I'm trying to use the DATEADD function, (that's sound stupid, i know) but when I try to use that.  Some rows the function was aplied and others don't.  Why?  I don't know.  I did the following validations:

1. I verified that the original column has the "Date" data type.

2. I verified that the new data type was "date" too.

3. I suposed that the issue was a confusin with day and month format, something very common in tsql datetime operations, but actually some rows with similar dates were converted and others not.

4. I have a PowerPivot with only 1700 rows by 30 columns in a laptop with 12 GB of ram.... i think that it is enough ram for this process

June 30th, 2015 8:24pm

This is Horrible,

I resolve my problema with this formula, i really want to know what the problem is?

=date(YEAR([cerado])-1,MONTH([Cerado]),DAY([Cerado]))

Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 9:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics