Michael Le

Michael Le

  • NA
  • 2
  • 0

Date manipulation in expression-based columns

Jun 1 2007 2:34 PM
I want to create an expression-based column in DataSet that can do some manipulation on another DateTime column. Specifically, I have a database column named DateEnrolled. I want to create a column called ExpectedGraduationDate, which is equal to DateEnrolled + 180 (days).

I have tried to put in the Expression property of the ExpectedGraduationDate the following:
1. DateEnrolled + 180 // did not work
2. DateEnrolled.Add(180) // did not work either

Does ADO.NET expression-based columns support SQL date manipulation functions? Is there any way to work around that issue?

Answers (1)