Formula for resetting the counter monthly in Lotus Notes
this is currently my formula:
Counter1 := @Elements(@DbColumn("":"ReCache"; "":"" ; "($CounterLookup2)"; 2)) + 1;
which is to create a counter for the # of documents saved. But i want it to be able to reset back to 1 every 1st day of the month. Can it be done? where will i put it?
thanks a lot.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 19, 2008 6:22 AM
UPDATED:
August 19, 2008 2:31 PM
RELATED QUESTIONS
- Create a unique tracking number for the document with this format (XXXXX-YY-MM)
- Append Query and Dmax()
- Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
- Microsoft Access Query Questions
- Formula to take three date fields and create on date field with the most recent date.
Answer Wiki:
Change your view to only select current year and month and I would add an error checker to code to allow for no documents, just in case.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
