Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

calculated date column returns the wrong day

Posted on 2012-03-27
4
Medium Priority
?
479 Views
Last Modified: 2012-04-15
=TEXT([Start Time],"ddd, dd MMMM")

is off by one day. why? it's an all day event in a standard calendar.
0
Comment
Question by:sullisnyc44
[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
  • 2
4 Comments
 
LVL 6

Expert Comment

by:wshark83
ID: 37772154
works fine for me...is the [Start Time] formatted as date?

I've tried the following:

24 March 2012      Sat, 24 March
24/03/2012 00:00      Sat, 24 March
24/03/2012      Sat, 24 March

25 March 2012      Sun, 25 March
25/03/2012 00:00      Sun, 25 March
25/03/2012      Sun, 25 March

26 March 2012      Mon, 26 March
26/03/2012 00:00      Mon, 26 March
26/03/2012      Mon, 26 March
0
 
LVL 7

Expert Comment

by:dhawalseth
ID: 37775982
Hi,
Use excel functions, e.g. if you have the datetime column use the following code to return date as string
column name= 'Date of Birth'
calculated column formula = YEAR(DateOfBirth)&"-"&DAY(DateOfBirth)&"-"&MONTH(DateOfBirth)
0
 

Accepted Solution

by:
sullisnyc44 earned 0 total points
ID: 37828395
you need to do this:


=TEXT(IF(TEXT([End Time]-[Start Time],"h:mm")="23:59",[Start Time]+1,[Start Time]),"ddd, dd MMMM")
0
 

Author Closing Comment

by:sullisnyc44
ID: 37847988
this works
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.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

609 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