Improve company productivity with a Business Account.Sign Up

x
?
Solved

calculated date column returns the wrong day

Posted on 2012-03-27
4
Medium Priority
?
485 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
  • 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

606 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