A set of LotusScript logging classes
The StartDate and EndDate fields in the Log forms are stored as text which causes problems with view sorting. Is there a reason why these dates are not stored as NotesDateTime objects?
Hi Chris. I wish I had a good answer for you because I normally do store date/time data in date/time format. I vaguely recall it giving me some issue and the quick fix was to revert to text, but I don't recall what the issue was because it was so long ago – likely years before I posted Flow here. I'll look into it again. A quick workaround for now would be to add a hidden column next to the Start column in the log view. The hidden column value should be set to Simple Function: "# in View (e.g. 2.1.2)". This will get the view to sort properly.