Adding DateTime Values in a Calculated Column of Dataset
Posted on 2007-10-03
I am trying to add a calculated "Due Date" column to a dataset using the expression property, but I am having trouble with the syntax. Due date needs to be calculated by subtracting a "Lead Time" field from a "Launch Date" field - both of which are on the same row as Due Date. The root problem is that the lead time is an integer and the launch date is a DateTime, so I can't simply add them. I'd expect to be able to use the AddDays method of a DateTime to easily add them together, but I can't figure out how to use the method within the Expression syntax.
If this tack won't work, I am open to other ideas to accomplish the goal of producing that Due Date column.