Solved

Date field History - Monitor Change!!

Posted on 2004-03-26
4
246 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now