[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

date field

Posted on 2006-06-15
8
Medium Priority
?
226 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 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
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.

 
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

834 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