Filter by Current year - 2

[James Glaser]

Greetings,

 

I'd like to set up a Deep See filter that is for the last 2 years.

 

So instead of having to do this:

[Invoice Date Year >= 2008]

 

It would be great to do something like:

[Invoice Date Year >= Current Year - 2]

 

Is this possible?

 

 

 

James Glaser

[Liang (Simon) Sha]

You can create a temp dimension using COS code:

 

$SYSTEM.SQL.DATEPART("yyyy",$zd($ztimestamp)) -2

 

And then use the temp dimension in the filter

 

[Invoice Date Year >= Temp Dim]

--

You received this message because you are subscribed to the Google Groups "InterSystems: DeepSee Community" group.
To post to this group, send email to intersystems-de...@googlegroups.com.
To unsubscribe from this group, send email to intersystems-deepsee-...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/intersystems-deepsee-community?hl=en.

[satish]

Hi James/Liang,

                       I would like like to give my inputs. We can also handle this case by simply writing below code in Pivot filter .

[Invoice Date Year >= $p($ZD($H),"/",3)-2}], I am using this syntax

 

 

Regards

Satish

[James Glaser]

Satish,

 

This seems like a far cleaner solution, I will give this a try.

 

Thank you!

James

[Kenneth Poindexter]

The example below is missing a {

 

It should read:

 

[Invoice Date >= {$p($zd($h),"/",3)-2}]

 

 

Kenneth Poindexter
Sales Engineer – Federal

 

 

p:. (301) 693-3391

e:. kenneth.p...@intersystems.com
| InterSystems | Caché -&- Ensemble |

 

---

From: intersystems-de...@googlegroups.com [mailto:intersystems-de...@googlegroups.com] On Behalf Of James Glaser

Sent: Monday, December 28, 2009 11:12 AM
To: intersystems-de...@googlegroups.com
Subject: RE: [InterSystems-DeepSee] RE: Filter by Current year - 2