Solved

date field

Posted on 2006-06-15
8
219 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now