+ Reply to Thread
Results 1 to 4 of 4

Problem with Notes Date/Time

  1. Problem with Notes Date/Time

    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!

  2. Re: Problem with Notes Date/Time

    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.

  3. Re: Problem with Notes Date/Time

    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

  4. Smile Re: Problem with Notes Date/Time

    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:)

+ Reply to Thread