datediff doesn't exist in C#, only in VB.net I think you can ask a timespan object to display itself as the interval that you are looking for. Oh how I wish that c# had a datediff equivalent. Good times.
tja On Nov 4, 1:49 am, Library <[EMAIL PROTECTED]> wrote: > You can only show the Date difference in days or months or years as > integer, > for that you have to find the diffrence using datediff function > like datediff(dateTo,DateFrom,Month) or datediff(dateTo,DateFrom,Day) > or datediff(dateTo,DateFrom,year) > this value itself is integer type. > > On Oct 16, 9:25 am, MikaylaLouise <[EMAIL PROTECTED]> wrote: > > > Hello, > > > I'm new to .Net development and I'm using Visual Basic. I need > > someone to assist me, I'm having a problem with my grid. Among other > > columns I have two (2) date columns: DateFrom and DateTo, I want to > > have another column which computes the difference between the first > > two dates and returns the value in a number format. Where should I > > put this "other" column in the table or in the dataset? I have tried > > to put it on my table with datetime as datatype and DateTo - DateFrom > > as the formula. But it returns a date value. How do I modify it to > > return the difference in a number format. > > > Thanks, > > > Mikayla
