i try to display report between 2 dates given from VB6.i gave crystal rept filename etc.i get error'incorrect'
367046
your question is not quite clear, may be you can explain it to me and i hope i could be a help to you, I been working with Data Reports in VB6 lately, and it works fine with me.
610941
6.month. 6. day. year.06. ?
184057
I hope that you don't actually have to work with Visual Foxpro as really should be ancient history...\n\nAnyway, here's some sample code.  You might need to replace some of the "my" references with actual DBF, field or filenames.  This opens a dbf, replaces a field with binary 0 characters and writes a message into a log.\n\n\n\nON ERROR DO errhand WITH ;\nERROR(), MESSAGE(), MESSAGE(1), PROGRAM(), LINENO()\n\n? 'Opening Table'\nuse my.dbf\n? 'Replacing MyKEY with CHR(0)'\nreplace all mykey with chr(0)\n\n\n? 'Writing to log file'\n*Write to log\nfh=FOPEN('my.log',2 )\nif fh=-1\n? 'Creating file...'\nfh=FCreate('my.log')\nENDif\nx=FSEEK(fh,0,2)\nx=FPUTS(fh, DTOC(DateTime()) + ' ' + Time() + ' mykey replaced with chr(0).')\nx=FCLOSE(fh)\n\n\nON ERROR  && restore system error handler\n? 'Quitting'\nquit\n\nPROCEDURE errhand\nPARAMETER merror, mess, mess1, mprog, mlineno\n\n? 'Error number: ' + LTRIM(STR(merror))\n? 'Error message: ' + mess\n? 'Line of code with error: ' + mess1\n? 'Line number of error: ' + LTRIM(STR(mlineno))\n? 'Program with error: ' + mprog\n\nDT=DateTime()\nfh=FOPEN("my.LOG",2)\nx=FSEEK(fh,0,2)\nx=FPUTS(fh, DTOC(DateTime()) + ' ' + Time() + ' Err: ' + LTRIM(STR(merror)) + ':' + mess + ', LINE:' + LTRIM(STR(mlineno)))\n*x=FPUTS(fh, 'Error message: ' + mess)\n*x=FPUTS(fh, 'Line of code with error: ' + mess1)\n*x=FPUTS(fh, 'Line number of error: ' + LTRIM(STR(mlineno)))\n*x=FPUTS(fh, 'Program with error: ' + mprog)\n*x=FPUTS(fh, 'Date/Time: ' + DTOC(DateTime()) + ' ' + Time() )\nx=FCLOSE(fh)\n\n\nquit
9806
This is bacaouse the report is pointing to a database Path which was hardcoded at the design time.\n\neg. While development the database path was C:&#92;Data&#92;Vbdata&#92;Myproject&#92;CRM&#92;data.mdb\n\nbut you might not have the database at same path. so ask the developer to rectify the mistake
721930
echo date("Y-m-d",strtotime("+5 days"));\n\necho date("Y-m-d",strtotime("+21 days"));
260803
Hmmm...Unusual Suspects?? :)\n\nI ran into this problem a few months ago.  Couldn't be assed with writing a VBScript.  It took me about an hour to clean it up by hand (it would probably take me the same to write and debug the script).\n\nHere's the easiest way to do this by hand:\n\n\nunless you already have a backup calendar-type folder somewhere for backup, Create a new outlook data file and create a new calender folder in it \nSwitch to Folder List view in outlook\nSelect your Calendar Folder\npress ctrl-shit-f to search\nHit find now.  \nSelect All entries (ctrl-a)\nhit ctrl-c (to place a reference to all items to your clipboard)\ngo into the backup folder, and hit ctrl-c.  That should create a copy of your 'real' calendar in this backup folder.\n\nThen, go back to the Advanced Find window.\na) If you used outlook's hollidays feature, sort first by location (I assume you are in the US), under United States, wipe them ALL out (you can always add these later with a few clicks)\nb) now sort by dates.  Wipe out all the old stuff you couldn't care less about\nc) now sort by Subject.\nd) time to work down-arrow, delete, down-arrow, delete, down-arrow, delete, etc...\n\ngood luck
1092752
Try boost.org\n\nBoost.Date_Time
495673
sure u have \nand try crystal reports\n\ni dont have to tell u the steps .. cause i dont remember really .. but try with msdn
772651
Try this one : http://goforit.unk.edu/vb6/default.htm
338128
#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}
387530
I'm not sure how accurate this is, but worth a shot!\n\nC:&#92;Documents and Settings&#92;xxxxxx>err -1073741790\n# for decimal -1073741790 / hex 0xc0000022\n  STATUS_ACCESS_DENIED                                           ntstatus.h\n# {Access Denied}\n# A process has requested access to an object, but has not\n# been granted those access rights.\n# as an HRESULT: Severity: FAILURE (1), FACILITY_NULL (0x0), Code 0x22\n# for decimal 34 / hex 0x22\n  ERROR_WRONG_DISK                                               winerror.h\n# The wrong diskette is in the drive.\n# Insert %2 (Volume Serial Number: %3) into drive %1.\n# 2 matches found for "-1073741790\n\nCheck this out as well:\n\nhttp://www.tech-archive.net/Archive/Windows/microsoft.public.windows.server.general/2004-09/\n\nGood luck!
186354
Easy - \n\nDim someDate As DateTime = DateTime.Parse(yourString)
882395
a) select <fields> from <table> where <date_field> >= '2006-01-01' and <date_field> <= '2006-12-31'\n\nb) select <fields> from <table> where <date_field> >= '2006-09-01' and <date_field> <= '2006-09-30'\n\nc) select <fields> from <table> where month(<date_field>) = 11\n\nd) select <fields> from <table> where <date_field> >= '2005-05-15 02:00:00' and <date_field> <= '2007-06-04 15:00:00'
1171534
Go to this site and put in that error #.\n\nRuntime Errors and others:\nhttp://support.microsoft.com/default.aspx?scid=kb;en-us;255058   \n\nGood Luck\n\nAlso, try going to "tools", "internet options"..."advanced".\n.."disable script bugging."....under "browsing"
589666
#include <iccclkeh.hpp> \n\nclass \n{\n       IccClock(UpdateMode update = manual);\n       IccAbsTime& ansTime();\n       void cancelAlarm(const IccRequestId* reqId= 0);\n       const char* date (DateFormat format= defaultFormat;\n            char dateSeparator='&#92;0');\n       unsigned long dayOfMonth(); \n       DayOfWeek dayOfWeek();\n       unsigned long daysSince1900();\n       long double milliSeconds();\n       MonthOfYear monthOfYear();\n       const IccAlarmRequestId& setAlarm (const IccTime& time,\n            const IccRequestId* reqId= 0);\n        const char* time(char timeSeparator= '&#92;0');\n        void update();\n        unsigned long year();\n        typedef enum{\n              defaultFormat,\n              DDMMYY,\n              MMDDYY,\n              YYDDD,\n              YYDDMM,\n              YYMMDD,\n              DDMMYYYY,\n              MMDDYYYY,\n              YYYYDDD,\n              YYYYDDMM,\n              YYYYMMDD,\n       } DateFormat;\n       typedef enum {\n              Sunday,\n              Monday,\n              Tuesday,\n              Wednesday,\n              Thursday,\n              Friday,\n              Saturday,\n       } DayOfWeek;\n       typedef enum {\n              January,\n              February,\n              March,\n              April,\n              May,\n              June,\n              July,\n              August,\n              September,\n              October,\n              November,\n              December,\n       } MonthOfYear;\n       typedef enum {\n              manual,\n              automatic,\n       } UpdateMode;\n };
856726
hi\nthe data source for the sub report are not set\nselect your sub report and right click and select edit\nthen on the sub report database set location. point to the new data location\ncould be a odbc connection
1017879
'declare variable\nDim cdate as DateTime\ncadte=System.DateTime.Now\n\n'declare variables\nDim dd as Integer, mm as Integer, yy as Integer\n\n'get the day value\ndd=cdate.Day\n\n'get month value\nmm=cdate.Month \n\n'get year value\nyy=cdate.Year