Solved

calculated date column returns the wrong day

Posted on 2012-03-27
4
468 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
InfoPath 2010 signature from external agent 4 69
Citrix sharefile 1 68
Redesign the sharepoint site. 9 65
User Profile Issue in SHarePoint 9 52
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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