Posting here out of self defence ... this is always one I forget and it doesn't seem to come up on the searches. Coded in PHP.
# 735540 3/11/2014
$timeoffset = 735540 - mktime(12,0,0,11,3,2014) / 3600 / 24;
$daychanged = ($_REQUEST[whichday] - $timeoffset);
$report = date("D jS M Y",$daychanged * 3600 * 24);
Very inefficient, but converts a day number from the FileMaker data I have into a Unix TimeStamp, which I have then formatted to report on Day. Month and Year (and day of week too) in my output.
My users far prefer "3rd November 2014" to "735540"!
(written 2015-02-15)
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles
G914 - Well House Consultants - Other Software [75] It's just not cricket - (2004-10-06)
[2106] Learning to Twitter / what is Twitter? - (2009-03-28)
[2191] RT @brento - a valuable source for the twitter newbie - (2009-05-20)
[2470] Windows 7 and Open Source Programming - (2009-10-22)
[2600] Go Programming Language and Courses? - (2010-01-26)
[2906] Switching from Adobe Photoshop to Gimp - testing it on animals - (2010-08-06)
[3213] Should I use Open Source or Commercial software? - (2011-03-26)
[3584] QR codes - graphics images that provide quick phone links - (2012-01-18)
[3599] Seeing how Melksham has changed over the years, via an iPad - (2012-01-30)
[3648] iPad and iPhone programming - our seminar weekend with Xcode - (2012-03-11)
[3896] An email marathon - (2012-10-15)
[3991] Email from Christopher Columbus to announce finding America? - (2013-01-29)
[4038] Using Pygments to colour our training examples - (2013-03-10)
[4303] Libre Office - unable to get past REOPEN WINDOWS? question - (2014-09-22)
S154 - MySQL - Designing an SQL Database System [59] MySQL - Pivot tables - (2004-09-22)
[361] Binary Large Objects or bars - (2005-06-27)
[375] Oops - I got my initial database design wrong - (2005-07-12)
[494] MySQL - a score of things to remember - (2005-11-12)
[515] MySQL - an FAQ - (2005-12-03)
[666] Database design - get it right from first principles - (2006-04-02)
[918] Databases needn't be frightening, hard or expensive - (2006-11-08)
[937] Display an image from a MySQL database in a web page via PHP - (2006-11-22)
[945] Code quality counts - (2006-11-26)
[1423] MySQL - table design and initial testing example - (2007-11-06)
[1575] Database design for a shopping application (MySQL) - (2008-03-15)
[1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24)
[2053] What a difference a MySQL Index made - (2009-02-25)
[2085] MySQL - licensing issues, even with using the name - (2009-03-16)
[2204] Images in a database? How big is a database? (MySQL) - (2009-05-28)
[2749] Delegate Question - defining MySQL table relationships as you create the tables - (2010-05-02)
[3270] SQL - Data v Metadata, and the various stages of data selection - (2011-04-29)
[3361] Blowing our own trumpet - MySQL resources - (2011-07-18)
[3494] Databases - when to treat the rules as guidelines - (2011-10-23)
H312 - PHP - Tips and Techniques [789] Hot answers in PHP - (2006-07-02)
[917] Syntax checking in PHP - (2006-11-07)
[1010] Dates, times, clickable diarys in PHP - (2006-12-28)
[1270] PHP Standalone - keyboard to screen - (2007-07-18)
[1649] Easy conversion - image formats, currencies and distances - (2008-05-21)
[1667] Checking server performance for PHP generated pages - (2008-06-06)
[1684] Two PHP include files to make easy web site indexing and navigation - (2008-06-21)
[1958] PHP - Parse error: syntax error, unexpected $end ... - (2008-12-23)
[1983] Keeping PHP code in database and running it - (2009-01-09)
[2025] Injection Attack if register_globals in on - PHP - (2009-02-04)
[2274] PHP preg functions - examples and comparision - (2009-07-08)
[2478] How did I do THAT? - (2009-10-26)
[2981] How to set up short and meaningfull alternative URLs - (2010-10-02)
[4074] A comment on comments in PHP - (2013-04-28)
[4310] Problem ... I want to print a series of numbered forms - (2014-10-05)
[4319] PHP - some quick fixes if scripts have issues, and how to use our support - (2014-11-19)
[4621] The power of scripting - (2016-01-12)
Some other Articles
The spirit of Java - delegating to classesWind Turbines - beauty or menace?Using the lead - passing arrays and other collections in JavaJava example - for loop and conditionals from course exerciseFileMaker Day to Unix Time conversionA Welsh valley - what the transport looks like in 2015Looking Forward - TransWilts Community Rail Partnership and TransWilts CICCampus - about the logos / way marks you have been choosing fromObjects - from physical to virtual or abstract - JavaHow healthy are the stars of stage and screen?