Sharepoint By Dummies

See Also: http://stephenbooth.brandyourself.com/

Date problem not resolved yet.

leave a comment »

Just had a mail from our systems administrators regarding the localisation settings on the server.  they’re all set to UK and the correct timezone so that’s not the cause of our inconsistent date interpretation problem.

To summarise whilst when entering dates they seem to be interpreted as UK format consistently when we try to use them in calculations they seem to be interpreted as US format unless they are not legal US format dates then they are interpreted as UK format.  So entering or selecting 11/07/2011 (11th July 2011) on the Newform.aspx page seems to work fine but in a calculation it will be interpreted as 7th November 2011 whilst 13/07/2011 will always be interpreted as 13th July 2011.  When we subtract one from the other we expect a 2 day difference but get 117 days difference.

Advertisements

Written by stephenboothuk

July 20, 2011 at 11:53 am

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Speeches I Would Have Given

What I would have said at conference

three65.blog

Maybe mildy useful to someone!

David Hunt, PE... Mechanical Engineer on the loose!

VALUE = Creativity + Diverse Experience + Critical Thinking

Not Literally Productions

Comedy, parody, tutorials and more!

catastraspie

A personal blog about having Asperger's

Dementia and Elderly Care News

News and research of interest to people involved in Dementia and Elderly Care

Marc D Anderson's Blog

A Knowledge Management Zealot Speaks Out

Codeless Solutions for SharePoint

Bryon Wyly is a SharePoint Developer dedicated to finding the limits to out-of the-box SharePoint solutions

gordonlyew.wordpress.com/

the political blog of gordon lyew

SharePoint Business Analyst

Just another WordPress.com weblog

%d bloggers like this: