topic Re: Date format with NamedValue(String, String) to d:date in Alfresco Archive

Date format with NamedValue(String, String) to d:date

jbaton — Mon, 13 Mar 2006 21:59:39 GMT

Hello Roy and people from the world,Could you tell me what is the format to use to create a NamedValue representing a date so that it gets stored properly into a d:date property.ThanksJBaton

Re: Date format with NamedValue(String, String) to d:date

rwetherall — Fri, 17 Mar 2006 10:00:07 GMT

Hi,

Should be passed in ISO8601 format. Try this format:

YYYY-MM-DDThh:mm:ss

Cheers,
Roy

Re: Date format with NamedValue(String, String) to d:date

jbaton — Tue, 28 Mar 2006 09:59:33 GMT

Roy,

Using this pattern with a SimpleDateFormat does not work.

Looking at some class called "*ISO8601*" (sorry I'm not in front of my pc right now) in the Alfresco code, it seems that the milliseconds and the timezone are needed too.

(I use d:datetime not d:date as previously said)

JBaton

Re: Date format with NamedValue(String, String) to d:date

kevinr — Tue, 28 Mar 2006 11:45:24 GMT

I believe the full ISO format date is:

YYYY-MM-DDThh:mm:ss.mmm+hh:mm

where mmm is miliseconds and +hh:mm is the offset from the GMT time zone, for example:

2005-09-16T17:01:03.456+01:00

Hope this helps,

Kevin

Re: Date format with NamedValue(String, String) to d:date

jbaton — Tue, 28 Mar 2006 21:17:14 GMT

Thanks Kevin, Roy,

I used the class org.alfresco.util.ISO8601DateFormat as a converter from java.util.Date to String for use with the web service api.

I think dates usage should be part of the (very helpful) samples.

Jerome BATON

Re: Date format with NamedValue(String, String) to d:date

pitti — Sun, 21 May 2006 07:52:36 GMT

Can u give me an example to store the d:date in NamedValue class
Help needed please

Re: Date format with NamedValue(String, String) to d:date

jbaton — Mon, 22 May 2006 08:45:39 GMT

Hi, I don't have the Alfresco sources in front of me so my help right now will be limited.

You'd better look in the alfresco sources at the class I mentionned in the previous post, you'll see the expected format for dates.

Then create a NamedValue
with
{YourNameSpaceURIAsDefinedInYourModel}yourPropertyName as key
and
the formatted date (as a String) as the value

I don't remember if I used d:date or d:datetime.
If ever you change a property type in an aspect, remember to remove the aspect off the space then to reapply it.

Hope it helps

Jerome BATON
http://www.wadael.org (photos, writings in french)

Re: Date format with NamedValue(String, String) to d:date

pitti — Wed, 24 May 2006 04:46:46 GMT

I changed my code according to your suggestions and it is working fine
Thanks for your immediate response
Regards
Keshav

Re: Date format with NamedValue(String, String) to d:date

dnalos — Tue, 14 Apr 2009 08:52:51 GMT

I have other problem like this. I have define a "date" in my customModel.xml like this:


         <property name="custom:datum">
            <title>Datum</title>
            <type>d:date</type>
         </property>
‍‍‍‍‍‍

And my question is, how can i search a Node with a date property? Like this?
@custom\:datum:2009-*-14

Thank you.