Hi, I am working on a report for which I need to identify Year to date values as a formulated column. Can any one help me on the same. Eg: =IF(Field (Start_date) >= "1/1/2011"),"Yes",NULL)
Rajesh - To clarify, you want to populate a formula field as "Yes" or "No"/null based on relative values in a Date/Time field with a range of dates. If the value in the date range field is over a threshold, or the maximum value in the field, then "YES" else NO/null?
It looks like you have one too many brackets in your formula (before the comma immediately before the "Yes"), and you need to convert your text ("1/1/2011") into a date first:
For those with access to 2.7, last night's build has a new DATE function, so the above formula... IF([Start_date] >= TEXTTODATE(DATETOTEXT(NOW, "yyyy"), "yyyy"),"Yes",NULL) ... can be simplified as: IF([Start_date] >= DATE(DATEUNIT(NOW, "year")),"Yes",NULL)