• Dates saved as string

    By Chris Hudson 1 decade ago

    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?

    • No, Not Really...

      By Corey Davis 1 decade ago

      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.