Problem with Notes Date/Time

[Database Administrator]

I'm sure there is an easy solution to this, but it's escaping me. I
have a LotusScript agent that creates documents. One of the fields is
a date in the future. Let's say 09/30/08. Everything I've tried
creates a date as this: 09/30/08 12:00 AM. I don't want the time it
the date field. It's causing problems with criteria in some of my
views that compare that date to another. I've tired populating the
doc field with a text format ("09/30/08"), but of course my form
doesn't like that, because it's supposed to be a true date field.
When the user manually creates a document with the form, the date
field is correct, 09/30/08 (no time).

Any suggestions greatly appreciated!

[Database Administrator]

Notes datetime is stored as a number, with integer representing the
date and the fraction as the time. So you just have to add the time
component in it.

I have similar problem in the past comparing 'exact' date. The
solution I had is to compare using @Day, @Month and @Year formula
functions. in the view. or use @Adjust to adjust both date fiels to
the same hour, minute and second.

[Database Administrator]

On Jun 20, 4:59*pm, JRT wrote:
> Notes datetime is stored as a number, with integer representing the
> date and the fraction as the time. *So you just have to add the time
> component in it.
>
> I have similar problem in the past comparing 'exact' date. *The
> solution I had is to compare using @Day, @Month and @Year formula
> functions. in the view. *or use @Adjust to adjust both date fiels to
> the same hour, minute and second.

Check out this recent tip to resolve this
http://www.assono.de/blog/d6plinks/D...ia-LotusScript

[ajithingmire]

You may need to format the date/time field before you save any value to it.
If you are setting a field value using formula then use @DateOnly formatting...If you are using lotus script then use "Format" function to format your date.

You may also check the options available in the field properties