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
