1st Day Problem

[narender123]

Hi Team,

=Sum({<Year={$(=Max(Year))},Month={$(=MaxString(Month))},Day={$(=Day(Today()-1))}>}amount)

its working for all date but when day=1 of August

then it will give 0

As per the logic it should return 31 july amount but its showing 0.

Please give me some idea.

Thanks in Advance.

Narender

[tresesco]

i guess, it's because your previous date is falling in another month and you have taken the max month in the set. I suggest, use date field rather than day.

[#3]

Why not use

=Sum({<Year={$(=Year(Today() - 1))},Month={$(=Month(Today() - 1))},Day={$(=Day(Today()-1))}>} amount)

?

But as tres says its best to use Date field instead.