GetEntryByKey using Time

HCL Domino Domino Forum
1

I am using getentrybykey in the lotus script agent.The key is

key(1)=parentdocument.UniversalID

key(2)=responsedocument.created(0)

In the view

first column - sorted by parentdocument.UniversalID

second column - sorted by date (formula used is @created)

Here, key(2) is the problem. It is returning string. But in the view, @created is returning “date” datatype.

How to convert this, “responsedocument.created(0)” into the “date” datatype?

2

Subject: GetEntryByKey using Time

I think, changing @created value to text data typw will work. for that u can use @text(@created).

Hope this solve the problem.

Piyush

3

Subject: RE: GetEntryByKey using Time

Thanks for your response

If I used like @text(@created), the sorting order is changed.

4

Subject: RE: GetEntryByKey using Time

The Created property does not return a string. If the element of your key array is a string, it’s because you declared the array as a string array, so that it gets converted when you do the assignment.

However, you haven’t realy convinced me that’s what happening. You’re not showing enough code to say for sure, and I’m not sure the code you showed is your exact code. You’re assigning key(1) and key(2), but by default, the first element of an array is element 0.