Datetime(yyyy,month,day,hour,minute,second)...
1 and 0 are (in this case) to give you jan 1 at midnight...
month(1=jan), day(1=first),hours(0=midnight), minutes(0=none) and seconds(0=none)
Where exactly are you using this formula (select expert, formula, running total?)
You can test a it by creating it as a formula field and placing it on the detail section. It will place a TRUE if the condition is met and a FALSE if not.
Break your condition into 2 pieces and test each one to see where it is breaking.
Formula 1= {Incident.Source} in ["Logged", "Active","Waiting"]
Place it next to the SOurce field on details to check it
Formula 2= {Incident.CreatedDateTime} in datetime(year(currentdate),1,1,0,0,0) to currentdatetime
Place it next to the Createdatetime field on details to check it
What is working and what is not?
Edited by DBlank - 23 Dec 2009 at 9:27am