Difficulty creating a view which displays a 'computed for display' date/time field

Discussion in 'Lotus Notes Technical Queries' started by jeff.fry, Apr 22, 2005.

  1. jeff.fry

    jeff.fry Guest


    I maintain a bug tracking db for my company. Each item created has a
    date_requested, which is a 'computed for display' date/time field. I
    have created a view which shows items with their

    Here is what I have been able to divine so far:
    * The date_requested is shown for all items created prior to 8/21/2003.
    * If I open an item from my date_requested view and then save the item
    (without changing anything) the item's date_requested will appear in
    the date_requested view.
    * If I open an item from any view which does NOT include date_requested
    and then save it, the date_requested will no longer display in the
    date_requested view. (In otherwords, the date only seems to display if
    the most recent time the item was saved was a time it had been opened
    from a date-displaying view.)

    Note, the date is clearly saved in each item - it is ALWAYS visible
    when I open the item for view or edit, and is consistant over time.
    (i.e. if the item was requested on 2/1/04, no matter where I open and
    save it from, the date_requested stays 2/1/04.)

    My goal here is to have a view which consistantly shows the date an
    item was first created. I am open to creative / alternate ways of doing
    this...any suggestions?

    Thanks in advance,
    jeff.fry, Apr 22, 2005
    1. Advertisements

  2. jeff.fry

    bugsy Guest

    Change the field from "computed for display' to "computed" and leave the
    formula as is.

    c-f-d fields are never stored "on disk" and so will not show in views.

    The formula for your c-f-d is probably a simple @Created function, if it is
    you can use the "Simple Function" called "Created Date" in the views column.
    bugsy, Apr 28, 2005
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.