Need Help

[jadams123]

Hi Everyone:

This is my code to get Week information. 

=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)

I need to modify this code to say today()-1

thanks,

J

[sunny_talwar]

Do you have a date field in your app? What is it called? What is its format?

[jadams123]

Yes I have a dimension called "Date" its mm/dd/yyyy

[sunny_talwar]

Then this

=Sum({$<Date = {"$(=Date(Today()-1, 'MM/DD/YYYY'))"}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)