2 Replies Latest reply on Feb 21, 2012 1:16 PM by Andy Kriebel

    Date calc is defaulting to count

    Andy Kriebel

      I have a field called Time that looks like 1 week starting 01-02-2012.


      I'm converting this to a date with the calculation Date = DATE(RIGHT([Time],10)).  However, when I drag this Date field onto the view, it defaults to CNT(Date) instead of a date field. 


      If I change it from the context menu to the date formats, but I want it to start that was as a Date field typically does.  The calculated Date field even has the calendar icon next to it.


      I swear I've run into this before, but I can't recall how I fixed it.


      Thank you!