Income MTD

[stevietm]

HI All

Im stuck again, im doing a project and i need to work out the MTD income and compair it with the prev MTD income.I just cant get it ryt!!!! If any one have any expressios that can work???

Regards

Thanx to all that can help....

[suniljain]

//Current month-to-date

inmonthtodate

(D, $(vToday), 0) * -1 AS CMTD,

//Previous month-to-date

inmonthtodate(D, $(vToday), -1) * -1 AS PMTD,