Easy Sum with Variable Question

[#1]

As part of this trying to convert an end user entered Date (on a calendar element) inside the expression, in a normal "If" statement it works fine as Date(vDateEntered) to converts successfully from number to date format. 

Sample:    =Sum(If(SalesDate=Date(vDateEntered), Sales)) works perfectly.

But converting this example to set analysis isn't converting to date mm/dd/yyyy format correctly.

=sum({<SalesDate={'=Date$(vDateEntered)}>} Sales) 

(just summing up sales for whatever date a person picked)

Can you tell me the right syntax for this?   Thanks much!

[#2]

=sum({<SalesDate={"$(=Date(vDateEntered))"}>} Sales)

Kiran Rokkam.

[#3]

Thats perfect, one new issue, SalesDate is stored in the format 1/31/2011 12:00:00 AM, so i need to use Date(SalesDate) to convert it to 1/31/2011.

How can i get that SalesDate conversion into your syntax?

Thanks again very much!

[#4 · Accepted solution]

Set analysis can be applied only on the field and hence its essencial to apply the format of the conditional expression to be same as the the field format. You can modify the expression to:

sum({<SalesDate={"=TimeStamp$(vDateEntered)"}>} Sales)

if it not works try

sum({<SalesDate={"=Text(TimeStamp$(vDateEntered))"}>} Sales)

Idea is to match expression return type to the field format. Try around with the expression and nplay around with the formats to match the return to the field. You can check the return by tryin the set expression in a text box.

Regards,

Kiran Rokkam.

[#5]

Thank you very much!