Forum Discussion
leandro_vegacr
Helper I
2 years agoCalculated column is not returning the desired value using Calculate
Hello all. I have two tables, equipment and snapshot. equipment has all assets, snapshot report on some issues with assets. snapshot has a date column called run_date, where the snapshot of the s...
- 2 years ago
30 days or one month? There's a difference...
- 2 years ago
DATEADD applies to the entire column. To shift individual dates you use EDATE.
lbendlin
Super User
2 years ago30 days or one month? There's a difference...
- leandro_vegacr2 years ago
Helper I
lbendlin , 1 month is the right thing, you are right.
This solves it beautifully. Thank you very much.
If it was not too much to ask, would you mind to clarify why my implementation gave a wrong calculation?
Again, thanks for your time and help.
- lbendlin2 years ago
Super User
DATEADD applies to the entire column. To shift individual dates you use EDATE.