How to set ‘date only’ or ‘time only’ values in fields through XPages

XPages always save date and time in a field

When a form has the fields with “date only” or “time only”, then the stored data format are different between Notes Client and XPages.

For example, I prepared the field with “date only” named “Date” as following (sorry, screenshots are all Japanese) :


And also field with “time only” named “Time”:


Now I saved a new document with this form from Notes Client (9.0.1 FP3), then I got following fields’ data.



As you see, “Date” field has “2015/03/02″, and Time field has”14:35:00”

As the next, I created the simple XPage to save a new document with same form and fields so that I can compare the data between Notes Client and XPages.


Below is the source code for Date field and Time field in XPages.

Date Field

	<xp:inputText value="#{document1.Date}" id="date1">
		<xp:dateTimeHelper id="dateTimeHelper1"></xp:dateTimeHelper>
			<xp:convertDateTime type="date" dateStyle="short">

Time Field

	<xp:inputText id="time1" value="#{document1.Time}">
		<xp:dateTimeHelper id="dateTimeHelper2"></xp:dateTimeHelper>
			<xp:convertDateTime type="time" timeStyle="short"

Each inputText specify date, time to the Type attribute of convertDateTime.

After saving a new document from this XPage, below is the screenshot of stored field data:



So both of fields have “yyyy/MM/dd hh:mm:dd ZZ” format.

Why you need to save “date only” or “time only” data from XPages?

I just don’t post this blog to argue which format is proper way and why XPages behaves differently.

In the real world, I think you or your customers already have the NSF apps and you may want to improve them as the web application by XPages. In that case, especially you decide to keep using the NSF from both Notes Client and XPages, then I recommend to adjust the field format to Notes Client one instead of XPages one so that all existing documents are supported both Notes Client and XPages without changing data.

Use setAnyTime()、setAnyDate() of NotesDateTime class

Maybe there are a lot of way to achieve what I want below. But one of easy way is using NotesDateTime class of SSJS.

		<xp:dominoDocument var="document1" formName="Form"
var dt:NotesDateTime = document1.getItemValueDateTime("Date");
var tm:NotesDateTime = document1.getItemValueDateTime("Time");
var notesDoc:NotesDocument = document1.getDocument();
notesDoc.replaceItemValue("Date", dt);
notesDoc.replaceItemValue("Time", tm);;

The SSJS above converts the DateTime field format by using setAnyTime()、setAnyDate() in PostSaveDocument event after saving the XSP document .



ケートリック株式会社 CEO & CTOをしています。
Notes/Dominoの開発を得意としますが、 C++ / Java / PHP / Javascript などの言語を使ってWEBアプリ、iPhone / Android アプリ開発などをしたりします。

I am owner of KTrick Co., Ltd. and Notes/Domino developer. HCL Ambassador (IBM Champion for 2015 - current). I am interested in web application development and preferred languages are Notes/Domino, C++ / Java / PHP / Javascript.

Author posts

— Uppsala

Morvall Färilavägen 27
334 21 Uppsala, Sweden
+36 4 14 27 33

— Stockholm

Svante Arrhenius väg 4
114 18 Stockholm, Sweden
+46 4 14 27 00

— Amsterdam

Hortensiastraat 181
Amsterdam, Holland
+31 069044317

— Barcelona

Calle Carril de la Fuente 87
Barcelona, Spain
+34 6384971780

Thanks for visiting.

Privacy Preference Center