AnsweredAssumed Answered

getasdate function

Question asked by DaveParry on Apr 30, 2009
Latest reply on Apr 30, 2009 by comment_1


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.