Solved

Display date/time in view.

Posted on 2004-04-05
9
233 Views
Last Modified: 2013-12-18
Good Morning! Experts.
  I have one simple question. I have created a date field with date/time set, computed for display and @Created, workd perfect
  But, when I try it in view with Date column sorted ascending and advanced format tab is set at date/time, it is not giving me any display. Thanks for your help in advance.
0
Comment
Question by:cyle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 10758543
Depending on the Notes-version you have (R5??) there can be problems with view columns (same column name used twice, e.g. if you duplicate a column). Otherwise, it should be a run-of-the-mill job. Try to make a new view with only a few columns in it,  but at least the date column. Did you check the Document Properties if the field was correctly filled??
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 10758549
From designer view sometimes you cannot see any changes , view it in client after saving the view !!

~Hemanth
0
 

Author Comment

by:cyle
ID: 10758561
I have Notes 6. Yes, the field has date/time, computed when composed and On display tab I had both date and time checked.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cyle
ID: 10758569
Yes, I do check it in client view.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 10758603
Just to be certain: check whether your date column has a unique name, compared to all other columns in the view. What happens if you replace the field (name correctly used?) with a fixed value?
0
 

Author Comment

by:cyle
ID: 10758685
I tried using company name on the date field and it gave a display with their names. In my document I have two fields names fld_date(@Created) and fld_createddate(computed field based on userrole). In view, I only use fld_date.
0
 
LVL 15

Accepted Solution

by:
Bozzie4 earned 50 total points
ID: 10758756
You are using "computed for display" : you can't use that in a view, because the value is not saved on the document.

In the view, use @created directly (in the view column)

cheers,

Tom
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 10760072
How could I have missed that!? Need new ink for my display...
0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 10760201
The simple solutions are the still the best  - and the most difficult to spot :-)

Tom
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Email relaying to outside address 4 185
How can I make DNS resolve different addresses dependant on location? 2 182
VBA Lotus notes 2 211
Lotus Domino server 11 73
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question