Problem facing to insert duration and date into data base

Aspose.Tasks Product Family
1

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.

2

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,