Free Support Forum - aspose.com

Problem facing to insert duration and date into data base

Hi,
I have facing a problem to entry MS Project date and duration into MS SQL data base.When I am try to insert actual date and duration (in day) having a data type formatting problem…Does not match data type so getting wrong date and duration.So I need a help to solve this problem.Please tell me what are the data base column format and how inserted perfectly.Help me as soon as possible.

Hi,

Aspose.Tasks for .NET returns the dates in DateTime format. You can easily convert the DateTime to any format using task.ActualStart.ToString("dd-MMM-yyyy") method.

Please check the attached sample for correct duration calculation in days, hours or minutes and feel free to contact us in case you have further comments or questions.

Best Regards,