anyone know how to get around the date conversions for different country's? for Australia the format is dd/mm/yyyy for America the format is mm/dd/yyyy not sure on other country's tho I'm coding with Delphi 7 in Australia and i cant find a way to convert the format to cater for world wide any help would be appreciated and 10 points for the answer that works
199590
I don't know if I understood your question, I am not a native englih talker but... \n1) try to use in your program the same date format, Delphi Example : TimePicker1.Format:='dd/MM/yyyy'\n2) try to detect the timezone and use DayOf, MonthOf, YearOf to extract the parameters, later you can encode the date using EncodeDate(....)\nI am sorry if my answers aren't matching what you are searching for, but, for further questions if you think I can help : Lseptimiu@yahoo.com
301346
Hi,\n\nIn the date field, you could enter GETDATE..\n\nSELECT GETUTCDATE(),GETDATE();\n\nSee which one suits you
279418
try to put a variable containing the date u specified then compare it with current date when the program is loaded.\nu can use something like this: \n\n\nset date italian\nenddate = 08-08-06\n*more than date limit\nif date() > enddate then  \n   messagebox("This demo version is invalid.")\n   clear events\n   release all\nelse\n   *still can use\n   messagebox("You can use this program.")\nendif\n\nu can improve it by save the date in registry.
593860
Since there are 27 integer time zones (from GMT - 12 hours to GMT + 14 hours), there's no way the whole world can have the same date at the same time, because there will always be points that are more than 24 hours apart, and those points (at least) will be in different days.
503799
Amricans use English but call it American language, they use dates, but use it wrong way and call it American style.\n\nAll the other countries use dates like 1st January 2007 etc, but Americans will say January 1st 2007. A bit wierd if I personally say so, my own view.
34148
I imagine business people pretty much need to stick with a standard Gregorian calendar, but they might have a different calendar when they deal with people in their own culture. It looks like there are Chinese, Hebrew, Islamic and Japanese calendars. I'm not sure how much they are still used, however.\n\nAs a side note, my industry (television broadcasting) often uses different monthly calendars. The month always starts on a Monday and ends on a Sunday. Months are either 28 days or 35 days long. It keeps things interesting around here!
3139
I recommend Ninotech Date Edit 4.0 (freeware)\nhttp://home.worldonline.dk/ninotech/freeutil.htm
446433
If have the same problem importanting my data.\nIn fact there are two problems, one is the separation between data columns, the other is the fact that in American notation for dates and numbers is different from the European one.\n\nIf you open a csv file  OpenOffice shows you a Text Import window.\nFirst you change the Separator options. In my case the Comma field is set, so I change it to semi-colon ; as my data are separated like that, but it might be that space or tab is the correct choice for your data.\n\nNow you have your data in correct columns.\n\nGo to the Fields lower on the pages. Each column is labelled Standard. Right clicking on the word Standard gives you various other options including several ones for the date, as well as the difference between American and European number format.\n\nIf you don't get OpenOffice to understand you, there is no other choice than to change the input file by hand or macro first.\n\nPS If a date does not contain the year, OpenOffice *always* assumes it is the present year. Therefore you have to change the date columns either by including the year explicitly, or in OpenOffice after import.\n\nPS2 I have everything automated with macros. After all it is an exercise one has to repeat often.
422673
if the millenium bug was a set up, obviously Microsoft would profit from it since it was rumored to be an intentional "glitch" in their operating systems for following date formats of mm/dd/yy instead of mm/dd/yyyy. the millenium bug fix became an auto update feature for Windows 98 up. Windows 95 and earlier operationg systems required their users to download the patch manually.
144529
#include<iostream.h>\n#define isleapyear(year) ((!(year % 4) && (year % 100)) || (!(year % 400) && (year % 1000)))\n\nclass Date\n{\nprivate:\nint  month, day, year;\n \npublic:\nDate(int month,int day,int year):month(month),day(day),year(year){};\nint isdatevalid();\nint weekday();\n\n};\n\n//\n//   return 1 if date is valid, 0 otherwise.\n//\nint Date::isdatevalid()\n{\n  if (day <= 0) return 0 ;\n  switch( month )\n{\n  case 1  :\n  case 3  :\n  case 5  :\n  case 7  :\n  case 8  :\n   case 10 :\n  case 12 : if (day > 31) return 0 ; else return 1 ;\n  case 4  :\n  case 6  :\n  case 9  :\n  case 11 : if (day > 30) return 0 ; else return 1 ;\n  case 2  : \n    if ( day > 29 ) return 0 ;\n      if ( day < 29 ) return 1 ;\n      if (isleapyear(year)) return 1 ;   // leap year\n    else return 0 ;\n}\n  return 0 ;\n}\n\n//\n// given month, day, year, returns day of week, eg. Monday = 0 etc.\n// tested for 1901 to 2099 (seems to work from 1800 on too)\n// \nint Date::weekday()\n{\n  int ix, tx, vx;\n \n  switch (month) {\n    case 2  :\ncase 6  : vx = 0; break;\ncase 8  : vx = 4; break;\ncase 10 : vx = 8; break;\ncase 9  :\ncase 12 : vx = 12; break;\ncase 3  :\ncase 11 : vx = 16; break;\ncase 1  :\ncase 5  : vx = 20; break;\ncase 4  :\ncase 7  : vx = 24; break;\n  }\n  if (year > 1900)  // 1900 was not a leap year\n    year -= 1900;\n  ix = ((year - 21) % 28) + vx + (month > 2);  // take care of February \n  tx = (ix + (ix / 4)) % 7 + day;              // take care of leap year\n  return (tx % 7);\n}\n \n \nint main()\n{\n  char week[7][10] = {\n  "Monday","Tuesday","Wednesday","Thursday",\n"Friday","Saturday","Sunday"\n};\n  Date *d;\n  int  month, day, year;\n  cout<<"Return the day of the week given the date."<<endl;\n  cout<<"Enter date in the form mm/dd/yyyy : ";\n  scanf("%d/%d/%d",&month,&day,&year);\n  d = new Date(month,day,year);\n  if (d->isdatevalid())\n  {\n    cout<<"The day of the week for this date is "<<week[d->weekday()]<<endl;\n  }\n  else\n    printf("%d/%d/%d not a valid date!",  month,day,year);\n  \n  getchar();   // wait \n  getchar();   // 2nd wait needed\n  return 0;\n}
503463
You have your time zone settings set to a zone an hour behind yours.... its not the daylight savings times options fault.\n\nMy guess you have set your clock to a zone that matches your time zone whilst daylight savings was in operation, such as GMT... now summer is over it has automatically taken the hour off, as it should, which as revealed the  time zone error.\n\njust double click your clock and the clock configuration box will open. go to the time zone and check that the correct zone is selected. \n\nIf it still does it, you may requesting the time from the wrong server.. you can adjust this on the internet time tab.  as long as the time zone is set correct, it trial and error to choose the correct server.\n\nif this still does not resolve it.. you can work around it by simply setting a time zone that is one hour ahead of yours... which would give you the correct time.\n\nRemember if you are successful and find the correct zone and the clock works ok..... and then it gets to summer and it automatically goes ahead one hour, and you are not in an area that does that... just uncheck the daylight savings box in the zone settings tab.\n\nGood luck!
107444
ok.. because we live in a different country ill share.. \n1-19-8-16-7-27..
656209
I assume you are referring to Excel.\n\nHighlight the cells you wish to format, then choose the format menu and choose "cell"  There's an option in there for date from which you can select many different formats, including British.\n\nI suspect the circular reference here is a red herring.  Circular references have nothing to do with how the date is formatted.  A circular reference occurs when the answer to one formula depends on the answer to a second formula, and the second formula's answer depends on the first.  It's usually more involved than that, but that's what it comes down to.  Excel should automatically draw arrows to indicate where the conflict lies.\n\nGood luck.
374757
Most of the non-English speaking world puts Day/Month/Year. Most of the English speaking world puts Month/Day/Year.\n\nNo big deal.
489089
GMT 0:00 is the first second of the day.\nAll countries times are eith + or - so many hours GMT.
623696
Yes, "Dec" as in "Decimal" means 10 and it is where we get "December" from.  Likewise "Novus" is Latin for 9. "Oct" like in "Octive" refers to 8, Sept is 7.  It was August (Augusus Ceaser) and July (Julius Ceasar) that caused the numbering to be different.  I suppose they decided to aim to somewhat start the year at the winter solstice, which they missed by about a week and half.\n\nOf course, originally the month was based on the lunar cycle -- "month" and "moon" are from the same root ("new moon" and "new month" originally meaning the same thing).  "Sept"ember does line up (roughly) with the Biblical 7th month when Yom Truah is held (now called "Rosh Hashannah").\n\nScripturally the new year starts with the new moon of the Aviv (Hebrew for "green").  They would test the new growth of barley at the new moon to determine if the barley was green and developed sufficently that they could parch the grain. If it was too early, the grain would have nothing inside the head.  But this new moon would generally be the first new moon after the spring equinoxe.  Whether anyone called that "March 25" back then is highly debatable.
341536
Right click on the cell and choose "Format Cells."  Make sure that under the Number tab, it is set to "General" or "Number."  Also, make sure that you are placing the equals sign (=) before the equation when typing it in.  It won't default to a date when you are indicating that it is an equation by using the equal sign (=6/5), but will default to a date without it (6/5).  Good luck!