How to compare date

[#1]

Hi,

How to use Analysis set to compare date:

I have two datetime parameters: Entered datetime and Completion Datetime. I want to get the Amount aggregation based on the datetime between Entered and Entered +7, I use this one, but it doe not work.

Sum({$<CompletionDate={$(<=DateEntered+7)}>}Amount)

Could you help me out? Thanks.

[sparur]

Hello, Isaac

try this:

Sum({$<CompletionDate={">=$(vDateEntered)<=$(=$(vDateEntered)+7)"}>}Amount)

where vDateEntered - variable with you value.

[#3]

Hi,

I need to use DateEntered as a field not Variable. Because I will put a dimension into chart.

And I have tested, this works:

sum({$<CompletionDate={"<=$(=(DateEntered))"}>}amount) ,

But how can I add 7 days into it.

[#4]

Hi Isaac,

please check the format of your fields "CompletionDate" and "DateEntered+7".

Maybe you are comparing a string with a number.

Are you able to upload a short example of your data (*.qvw hopefully)?

Rainer

[sparur]

Can you post a small qvw example?

[#6]

Hi,

My Datetime format is '2010/01/01 00:00:00'