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

    Hi,

    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
    date_requested...sometimes.

    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
     
    jeff.fry, Apr 22, 2005
    #1
    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
    #2
    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.