[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

date field

Posted on 2006-06-15
8
Medium Priority
?
225 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
[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
  • 5
  • 3
8 Comments
 
LVL 43

Accepted Solution

by:
Steve Knight earned 500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

649 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