[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Display date/time in view.

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
cyle
Asked:
cyle
  • 3
  • 3
  • 2
  • +1
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
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
 
HemanthaKumarCommented:
From designer view sometimes you cannot see any changes , view it in client after saving the view !!

~Hemanth
0
 
cyleAuthor Commented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
cyleAuthor Commented:
Yes, I do check it in client view.
0
 
Sjef BosmanGroupware ConsultantCommented:
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
 
cyleAuthor Commented:
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
 
Bozzie4Commented:
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
 
Sjef BosmanGroupware ConsultantCommented:
How could I have missed that!? Need new ink for my display...
0
 
Bozzie4Commented:
The simple solutions are the still the best  - and the most difficult to spot :-)

Tom
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now