sum between dates

[#1]

hi all,

could someone assist with syntax here. I'm trying to sum between the beginning of year to the current date.

Sum({<Date = {">=$(vYearStart) <=$(vToday)"} >} Field)  

vYearStart= YearStart(Today()) 

vToday =Date(Today())

[sunny_talwar]

May be try like this

Sum({<Date = {">=$(=vYearStart) <=$(=vToday)"}>} Field)

Also, look here:

Dates in Set Analysis

[#3]

Ah I figured out syntax wasn't the issue. The field I am summing does not have a date link. Only a month. Is there a way to do a sum between first month of the year and the current month?

[sunny_talwar]

How does your Month field look like?

[#5]

Its written out fully

January

February

March

etc

[sunny_talwar]

And can you share how is this field created in the script? Essentially, is this a date field or not?