2 Replies Latest reply on Apr 30, 2009 2:51 PM by comment_1

    getasdate function



      getasdate function


      I'm trying to add invoice values for individual months. I have created a field using a if statement and getasdate    If (Date = GetAsDate("4/2008"); Value ; 0 )

      and a summary field to display the total. 

      However it doesnt work, I think because the format of date field is dd/mm/yyyy.  Have tried wildcards ** in place of dd still no luck.

      is there some way round this or a better way of doing this.