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!

      Andy