How to define a variable of datetime datatype, having null value?

38 views (last 30 days)
I am working on water level timeseries in a project. For this I have to compare water level with a threshold value and corresponding date of the respective water level is to be recorded in a datetime variable. If the water level value is not greater than the threshold value, then corresponding date variable must be null or empty. Please guide any suggestion?
Here is my sample code:
highObservations_date = datetime; %this variable has current datetime, it must be initialized with % a null value
highObservations_value = 0;
highLevelCounter = 0;
% set threshold to be considered as High water level
threshold_High_waterlevel = double(median( BreedingSeason_waterlevels.timmendorf_water(:,1)));
for i= 1:size(BreedingSeason_waterlevels,1)
if( BreedingSeason_waterlevels.timmendorf_water(i,1) >threshold_High_waterlevel )
highLevelCounter = highLevelCounter + 1;
highObservations_date = BreedingSeason_waterlevels.timmendorf_time(i,1);
highObservations_value = BreedingSeason_waterlevels.timmendorf_water(i,1);
end % end of if
if (highLevelCounter >1)
break;
end % end of if
end % end of for loop

Accepted Answer

Steven Lord
Steven Lord on 15 Nov 2018
The standard missing value for a datetime array is NaT.
  2 Comments
Steven Lord
Steven Lord on 15 Nov 2018
NaT is not equal to any other datetime, not even another NaT. Use the isnat function to detect NaT values in your datetime array just like you would use isnan to detect NaN values in a double array.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by