Help with @Explode

HCL Domino Domino Forum
1

Hi everyone,

I’m trying to create a view that display documents created between two dates ([01/01/2006] - [12/31/2006]. I’m using the @Explode([01/01/2006] - [12/31/2006]) in the view selection formula but not getting any documents. Can you please help.

TIA!

2

Subject: help with @Explode

Why not use @Created>-@date(2006;01;01) & @Created<=@Date(2006;12;31) ?

Mike

3

Subject: RE: help with @Explode

Thanks Mike. That worked great!

I also have a bunch of dates in a column that I’m trying to extract one of them from. The senario is that I’ve an approval date that is captured in one field (approvaldate). I’m trying to extract (pull out ) a date one user approve a request. Is there any formula i can use? I tried @Implode with out any success.

Thanks again!

4

Subject: RE: help with @Explode

When you say “column”, do you really mean a multi-value field on the document?

If so, have a look in the Designer help at @Subset

HTH

Mike

5

Subject: RE: help with @Explode

Yes, I mean multi-value field. There are 12 dates in the list. I would like to extract one date (the date that is listed on #10). How would i do it?

6

Subject: RE: help with @Explode

To get started (this will help you in the future) Open Domino Designer, press f1 for help, click search, type in @subset Look at description, look at examples, apply logic:

First10 := @SUBSET(DateList;10);

@SUBSET(First10;-1)

7

Subject: RE: help with @Explode

You could also use subscripts to access list elements starting with Release 6. But again before attempting any development it would do you a lot of good to look up Domino Designer Help first! Honest!

8

Subject: RE: help with @Explode

Thank you, All! I used your suggestions and able to extract the specific date now.

Thanks again!