Solved

date field

Posted on 2006-06-15
8
222 Views
Last Modified: 2013-12-18
Hi all,

Why would a date field display date and time when its properties are flagged to display date only(display time is unchecked)

It is a computed field from two other date fields which also only displaying dates

Any ideas will be appreciated.

Varvoura
0
Comment
Question by:varvoura
  • 5
  • 3
8 Comments
 
LVL 43

Accepted Solution

by:
Steve Knight earned 125 total points
ID: 16910166
Maybe it contains text?  Check field properties in Document properties..
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 16910340
Sometimes it's the obvious :-)  Cheers for the points.
0
 

Author Comment

by:varvoura
ID: 16911655
Steve,

It seems that I have another one of those which is date time list range, and display the time although the display time property is unchecked.
What can I do with this one? it is mucking up all my comparison formulas.

Thank you
0
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!

 
LVL 43

Expert Comment

by:Steve Knight
ID: 16915203
Could you not strip off the time part when you do the comparison:

@TextTToTime(@Text(DateField);"S0")) perhaps?

The comparisions will use any value in the field so if a time component is present it will get checked against unless you remove it as above or other similar methods IMHO.

Steve
0
 

Author Comment

by:varvoura
ID: 16918211
Steve,

This field was a computed field and one of the field it was computed from had date/time. Once I fixed the first field, this field then displayed everything correctly.

I'll keep your forumula in mind for other times, it is a great idea.

Thanks for all your help with this.

0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 16918223
No problems,  any updates on your other Q's ?

Steve
0
 

Author Comment

by:varvoura
ID: 16919799
Which one are you talking about?

I am actually looking for help with my open calendar question.
However to make it easy, we can modify the loop that we work on with the list to incorporate the change the I need to make to the calendar view.

Really, all what I need to do is to test within the loop the time difference between the two times, then if the user answer "Yes" on the prompt, i would move all dates accordingly otherwise only this date(which was dragged then)

I am going to see if I can do something about this now, do you have any ideas to help with this one?
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 16919862
You've closed all the ones I commented on since I made the comment.  Will have a look at your others when I get some time, building some servers at the moment

Steve
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

733 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