YTD2date

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: YTD2date

sunny_talwar — Thu, 27 Oct 2016 16:09:53 GMT

Try this:

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

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

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