How do I convert this one just to date only (DDMMYY)?“4/05/2009 12:28:00 PM”
I just want to show 4/05/2009 in the column view
Subject: convert to date only
@Date
Subject: RE: convert to date only
i used @date but it comes up with error incorrect data type for function text expected. I think it is coming from the Now() script which I have saved the data via lotus script. How do we get around this issue.
Subject: Is the field a datetime field or text? Look at the doc properties.
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
it is a date field but maybe the lotus scripts might have converted some of the data to text
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
Please read: Working with Date/Time Values in Lotus Notes
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
I fixed the issue by formatting it to short date.Call docc.ReplaceItemValue(UCheckOutDate,Format(Now(),“Short Date”))
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
No, you didn’t fix the problem, you fossilized it – made it permanent and, if anything, worse. A fix would have been to make sure the field contained an actual date, and that would have been done best by using a NotesDateTime object.
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
Yes and also if you want the date ONLY in the field when using the NotesDateTime object, do it like this:
Dim dtNow as New NotesDateTime(now)
Call dtNow.setanytime
Call doc.replaceItemvalue(“MyDateOnlyField”,dtNow)
Notice I stick the WHOLE NotesDateTime object in there and not one of the properties. This gives you a date-time field on the document with no time components.
Subject: RE: Is the field a datetime field or text? Look at the doc properties.
If you got that out of my article, I need to rewrite it. Seriously, did you read it?