Solved

Date field History - Monitor Change!!

Posted on 2004-03-26
4
252 Views
Last Modified: 2013-12-18
Ok Guys .. Thanks for all answers.
However .. I still am having problem with the data field. The Name & Module fields are captured correctly. However the date history is captured only for the most recent entry (Change).

Example - History Fields

JOHN SMITH   -    ABC   -   03/26/2004
MARK F          -    BCD   -   Blank (No date captured)
MIKE B           -    XYZ   -   Blank (No date captured)

HISTORY FIELD-1 : @If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); AM_History; AM : AM_History)

HISTORY FIELD-2: @If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); Salescode_History; Salescode : Salescode_History)

DATE HISTORY: @If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); @Now; @Now : Inactive_Date) - THIS DOESN"T WORK!!!!
It only captures the most recent one..
0
Comment
Question by:chinnaji
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 9

Accepted Solution

by:
Arunkumar earned 50 total points
ID: 10691601
What is the datatype of Inactive_Date ?

If its a Text List then....

Try to make an @Text(@Now) like this and test...

@If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); @Text(@Now) ; @Text(@Now) : @Text(Inactive_Date))

Regards,
Arun.
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 10707203
Oops! Not

    @If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); @Now; @Now : Inactive_Date)

But

    @If(!@IsDocBeingSaved | (@Subset(AM_History;1) = AM & @Subset(Salescode_History;1) = Salescode); Inactive_Date; @Now : Inactive_Date)

That should be the formula of the date history, and the date history field is, I assume, named Inactive_Date
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
authenticating IIS users via a Lotus Domino Server 5 197
Lotus Notes 8.5 1 167
Migration: Lotus Notes to Exchange 2013 10 345
Lotus Notes – Domino Document Manager 4 131
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question