Is there a way or a sample of using the days360 function, or is there an example of using the infragistics.excel functions in code-behind? I can't find any and I've been looking most of the day.
DateTime startDate = Convert.ToDateTime("12/15/2013");
DateTime endDate = Convert.ToDateTime("12/13/2014");
int days360 = DAYS360(startDate, endDate)
I've looked every place, but can't fine any samples of actually using excel functions in code-behind.
I can't use the functions in a text box, there are a bunch of calculations done on the dates before the days360
Hello csnyder,
You could try for example the following approach:
DateTime now = DateTime.Now; DateTime then = new DateTime (1, 1, 2005); TimeSpan diff = now - then; int days = diff.Days;
For additional reference you could check:
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/0625cefa-461b-4a3c-b7f0-d39d06741b70/
http://stackoverflow.com/questions/5320885/c-number-of-days-between-two-dates
Please let me know if this helps.