How to display Date as output in Appdesigner?
9 views (last 30 days)
Show older comments
Hi I am trying to find the earliest start date and the latest finish date for activities.
I have received inputs from user and stored it in an excel file.
Now how to find the earliest start date and the latest finish date and also display it to the user. Also calculate the total cost ie. sum of variable values when the update button is pushed.
% Button pushed function: SaveButton_2
function SaveButton_2Pushed(app, event)
n = app.EnterTotalNoofActivitiesEditField.Value;
% Create table array
sz = [n 4];
varTypes = {'string','datetime','datetime','single'};
varNames = {'Activity','Start Date','End Date','Planned Value'};
t = table('Size',sz,'VariableTypes',varTypes,'VariableNames',varNames);
% Create table UI component
uit = uitable(app.UIFigure);
uit.Data = t;
uit.ColumnEditable = true;
uit.Position(3) = 310;
end
% Button pushed function: RollupButton
function RollupButtonPushed(app, event)
uit = findobj(app.UIFigure,'Type','uitable');
sheet = 'Budget';
writetable(uit.Data,'EVM.xls','Sheet',sheet);
end
% Button pushed function: ExporttoExcelButton_2
function ExporttoExcelButton_2Pushed(app, event)
winopen('EVM.xls');
end
% Button pushed function: UpdateButton
function UpdateButtonPushed(app, event)
end
0 Comments
Answers (1)
Walter Roberson
on 5 Apr 2022
If you are using datetime() objects, then min() and max() are available for those.
You can set the Format property of a datetime object and then string() the object to get text.
3 Comments
Walter Roberson
on 5 Apr 2022
The first output of xlsread() is never a datetime object. It might be a serial date number, but datetime() applied to serial date numbers requires a "convertfrom" option.
You should consider switching to readtable()
See Also
Categories
Find more on Install Products in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!