Subtracting date fields in lotus notes
I need to subtract two date fields in order to get the number of days as the difference. I tried subtracting them in the "Default Value" section of the Field. But the message "Incorrect Data Type for operator or @function appears on the screen. The field was defined as editable / number field.
Can you please teach how to properly solve this problem using the @function in the "default value" section of the field property?
Thank you for kind help.
I have an NSF that contains an email message with two attachments. One of the attachments is corrupt, and if I attempt to save it, Notes displays this message The attachment may be corrupted. Would yo
I'm dealing with a client who uses Lotus Notes and would like the ability to use it on several different computers as he travels around a lot. He's gone out and invested in a portable hard drive so I
I'm trying to create an update system in which the user is told when the update was posted in the following format: Posted by user1 1 hour, 10 minutes ago. When the update is created the date is store
In order to make my notes run faster, I searched both on Google and w3 and found there is a jvm.properties file which contains the JVM arguments for notes incl. Xmx and Xms. I tuned them and it work
I'm testing an email and it is laid out correctly in all the clients except for Lotus notes 6.5 and 7. The problem occurs when td's become very small (less than 10px). Those td's then do not get any s
We are migrating several applications from Lotus Notes to SharePoint. The applications consist of standard document libaries, lists, and forums. What tools are available either free or commercial to m
I have a windows service written in .NET/C# which reads emails from a Domino mailbox. Currently I am using the Lotus Notes .NET Interop to achieve this. However for this the Lotus Notes Client needs t
I know that you can export fields from Lotus Notes as text. How do I export pictures and attachments from Lotus Notes? Can I select all the documents in a list and then export all the pictures and att
I am very new to lotus notes and java. I am trying to get all documents which are modified by specific time. I can not use getallmodifieddocuments because , notes version R5. I am trying to get it as
I have been asked to retrieve and update data remotely to our Lotus Notes database. I installed the Lotus Notes NotesSQL ODBC driver on my 64 windows 7 PC. I can read data from a Notes view just fine
I recently joined a company. I need to work on Lotus Designer software, and command and Lotus Script. I really have no idea of where to start. I have to learn from scratch on my own. Can any of you pl
I am sending emails to different users in my corporation. Some of our clients use Lotus Notes (8). These emails are generated by the server. Inside this email (HTML formatted), there is a link to a m
On saving an XPage I would like to save all values of computed fields in the underlying Notes form. The reason is that when opening the document in the Notes client I want to have the values of this c
I'm looking for a way to start Lotus Notes and control its utilisation from a vb.net project. By controlling I mean litle things like getting the window position, closing active document and other stu
i need help for send a mail in the Lotus Notes using python, appear that the win32com can do it, but i don't found any complete example or tutorial. My idea is a simple function like it: from win32com
I am looking to insert a blank line into the body of a lotus notes email. For example: Currently my body displays this: Hi this is the body of my email. <img></img> And I want the body
I have a project to create a plugin for Lotus Notes, which can create new calendar entries and gets data of existing calendar entries. Preferences Windows 7 Client: Lotus Notes 9 (Social Edition) Ser
I would like to create a report from a project management system that has been created in Lotus Notes. I have connected to ORACLE from SSRS before, can I connect to the Lotus Notes DB?
What is the maximum number of characters for a Lotus Notes text field? In Lotus Notes clients, I am encountering a 32K error.
I'm currently migrating a Lotus Notes application to XPages. The application contains several formulas which use @Transform and as there is no SSJS equivalent for @Transform, I'm wondering how bes
Is there a way in Lotus Notes to search a view without using URL commands. Thanks.
We are having an issue with a dll in a notes plugin. When we call this: NotesFactory.createSession(); we get this error: Unable to create view: nlsxbe (The filename or extension is too long. java.lang
I have some VBA code that takes the various email parts as inputs and creates an email message in Lotus Notes, and sends it from a group mailbox. It sends the email out to a recipient and CC recipient
I have written a simple mail client for Lotus Notes and I try to encrypt a message. My approach according to the C++ API help was the following: LNMailMessage msg; session.CreateMailMessage(&msg);
Basically I need to access some records or data from a view in lotus notes itself. I can't use use the @DBLookup since our target is not to refresh the form. I know that using AJAX it is possible thou
Saving file in Lotus Notes have two problems: the full-text search is slow and inefficient the single database cannot be very big(related to the os file system). How can i resolve the problem and Ar
In particular, I have to extract all the messages and attachments from Lotus Notes files in the fastest and most reliable way. Another point that may be relevant is that I need to do this from a secon
I have a lotus notes web form in which computer-illiterate customers will use to attach Excel files and submit them to our company. I am using a Lotus Notes File Upload Control to allow them to do thi
there is a method using lotus notes @formula to recover a value contained in a view (view1) to use it in the selection formula of another view(view2) ? View1 contain only ONE column and ONE document.
Got lotus notes version 8.5. I need it to show html img properly. <a target='_blank' href='http://www.foo.com'alt=external-link><img class=document-url-image src=http://foo.com/images/ic
Both the systems described are Windows XP with Lotus Notes 8.5. I have a Java app (sample code below) that uses notes.jar to interact with Lotus Notes. The app works fine on a system that has notes.in
Is it possible to write code in java or Lotus script or any other programming language to migrate LN documents to sharepoint list? I have a Lotus notes database, we are in plan to migrate from lotus n
I am very new to lotus notes. Recently my team mates were facing a problem regarding the Duplicates in Lotus notes as shown below in the CASE A and CASE B. So we bought a app named scanEZ (Link Abou
I want to setup Lotus Notes on my laptop to mess around with it. I am trying to setup my email, but my email through verizon.net requires authentication. I have it setup in Outlook 07, but Outlook doe
I am using Lotus notes Client 8.5 and i want to export mail items into DXl file. can anyone tell me the steps to convert notes doxument into DXL file?
There is a computed numeric field called: Sum. As its name says, it is basically a percent, that changes every time a user completes other fields. Initially, it is 100 (%). I created a configuration z
I have problem with data format. When I create document in lotus database (in lotus client) date is inserted without time Field Name: data_fim Data Type: Time/Date Data Length: 8 bytes Seq Num: 1
Lotus Notes client 8.53 with FPx and Upgrade Pack 1 are installed to clients using a package management solution. I need to check that it works and actually get the Upgrade Pack installed. The Fix Pac
I have a lotus.domino.Item instance. item.getType() returns Item.ATTACHMENT (meaning the item represents and attachment) When I System.output the item.getValueString() it writes out the FileName and
I am using Lotus notes 8.5 c++ api to create a new notes document like email,calendars, tasks,etc. i am not able to put html data in any notes document body.When i insert html data, it shows as Html c
I'm stuck with this problem for days I have to read a specific mailbox in lotus notes and bring all the content into an excel spread sheet but so far I have only been able to read the default inbox an
I am using a Java based Portal Platform. I need to show within my portal information stored in Lotus Notes. Considering security issues, what are the recommended ways to do this? Are there any open so
I am doing a data migration from Lotus notes to another type of software that does not support Rich Text Fields. I am trying to write a VB 2005 program that will take any rich text fields that are fou
I need to export (save to) hard drive my Lotus Notes emails. I figured out the way how to save attachments to HDD, but I can't figure out the way of how to save the whole email. The code below shows h
Using Powershell, I need to retrieve an Internet email address from a Lotus Notes names.nsf address book. Within Notes, I can see the internet email address I want to retrieve. It is on the Basics tab
I am trying to sync up a SQL Server table with a Lotus Notes database. I have set up the NotesSQL ODBC driver and have been able to insert, update and select from the notes database form using the Act
I have a View in Lotus notes by formula. The View is as follows by Org Exec \ Organization \ Total Headcount I have a show twistie when row is expandable enabled and Categorized selected as Type
Lotus Notes Client crashed for one of the user few days back. After that we had him install the Lotus Notes twice but the issue continues. PLease find the NSD below. It shows ntdll.EtwEventEnabled at