I have a Data Grid View which displays a few things from the database, one of the information being displayed is the Date,The date is set in Clarion and i want to change it so it gets changed to the date we see it as today.
I have a formula which can convert the to clarion date to todays date, but how do i display it in the grid view for all the rows.
Now todays date is 16/5/2011 (UK FORMAT)
Clarion Date is 01/01/1900
Clarion Days to this date is : 36161
To Calculate to clarion the formula is : 16/5/2011 - 01/01/1900 = 40678
40678 + 36161 = 76839
Now the result shown above is the format my GridView is being populated, so i want to change the numbers from 76839 to date format which will be todays date.
Can anyone help? as GridView will have many different Clarion Dates the formula will need applying to, but the main thing is to make sure one attribute in a gridview can be displayed differently.
Can someone please help thanks :)