YTD2date

[#1]

Dear Community

I have the following formula for YTD :

sum(if(year2date(TIME,0,7,MONTH),Payment))

TIME defined as Date#(MONTH)AS TIME in script load

MONTH defined as mm-yyyy(e.g Jul 2016)

Getting no return on formula

I have an Idea that it might be my TIME formatting creating a problem

Not sure. Please advise

Tx

[sunny_talwar]

Try this:

Date#(MONTH, 'MM YYYY') as TIME -> if MONTH is Jul 2016

or

Date#(MONTH, 'MM-YYYY') as TIME -> if MONTH is Jul-2016

Not the difference in - between MM and YYYY between the two above scripts.