DateTime properties and methods

• Jon Spink

  SSCarpal Tunnel

  Points: 4010

  More actions

  July 5, 2005 at 1:47 am

  #110569

  To put today's date in an expression you type 'datetime.today'. How do you express this date last year? There is documentation to suggest that datetime.addyears(-1) might work but it doesn't, at least not immediately. Any ideas?

• gallan-229957

  SSCommitted

  Points: 1520

  More actions

  July 5, 2005 at 11:37 am

  #570956

  datetime.today.addyears(-1)

• Jon Spink

  SSCarpal Tunnel

  Points: 4010

  More actions

  July 6, 2005 at 1:56 am

  #571126

  brilliant! Now tell me where did you find that out, in BOL? where is the full list of such properties and methods?

  thanks.

• gallan-229957

  SSCommitted

  Points: 1520

  More actions

  July 6, 2005 at 11:06 am

  #571403

  Actually I just hacked it, meaning I just tried it with that syntax and it worked. LOL.

  Now I did a search and found:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemGlobalizationKoreanCalendarClassAddYearsTopic.asp

  http://msdn2.microsoft.com/library/991wfdee(en-us,vs.80).aspx

  http://msdn2.microsoft.com/library/cw8hzdwz(en-us,vs.80).aspx

  This is actually .NET code, not specifically "Reporting Services" code.

• Jon Spink

  SSCarpal Tunnel

  Points: 4010

  More actions

  July 7, 2005 at 1:52 am

  #571663

  you'd think this sort of thing would be documented somewhere obvious, but... anyway thanks.

• nigel.

  SSChampion

  Points: 11636

  More actions

  July 7, 2005 at 3:50 am

  #571695

  As Greg mentioned the DateTime class (actually System.DateTime) is part of the .NET framework, and is documented here: 

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclasstopic.asp

  Nigel
  How to post questions