Author | Topic: Need Help with ActiveX and MS Access Date/Time Field | |
---|---|---|
Chris Chambers | Need Help with ActiveX and MS Access Date/Time Field on Sat, 15 Jun 2013 16:31:45 -0700 Hi Folks, Has anyone got any expericence with MS Access Data/Time Field which uses Numbers instead of dates and combines both date and time into a single numeric expression. How can we, when using xbase++ both access and write back to this data as you may recall 0 is expressed as 12/30/1899 12:00:00 AM I need this access for the MS MAPPOINT integration where the StartTime property makes use of this setting and requires a date field only. What do what have in Alaska that can look like a date field yet provide this functionallity for Microsoft. Any help would be great appreciated. Thanks Chris Kelowna BC Canada | |
Wolfgang Ciriack | Re: Need Help with ActiveX and MS Access Date/Time Field on Sun, 16 Jun 2013 18:10:17 +0200 Am 16.06.2013 01:31, schrieb Chris Chambers: > > Hi Folks, > > Has anyone got any expericence with MS Access Data/Time Field which > uses Numbers instead of dates and combines both date and time into a > single numeric expression. > > How can we, when using xbase++ both access and write back to this data > as you may recall 0 is expressed as 12/30/1899 12:00:00 AM > > I need this access for the MS MAPPOINT integration where the StartTime > property makes use of this setting and requires a date field only. > > What do what have in Alaska that can look like a date field yet > provide this functionallity for Microsoft. > > Any help would be great appreciated. > > Thanks > > Chris > Kelowna BC Canada > Hello Chris, for MS Mappoint i use static function D2DT(vdat, vtim) return str(year(vdat),4)+"-"+strzero(month(vdat),2)+"-"+strzero(day(vdat),2)+" "+vtim+":00.000" | |
Chris Chambers | Re: Need Help with ActiveX and MS Access Date/Time Field on Mon, 17 Jun 2013 11:30:43 -0700 On Sun, 16 Jun 2013 18:10:17 +0200, Wolfgang Ciriack wrote: >Am 16.06.2013 01:31, schrieb Chris Chambers: >> >> Hi Folks, >> >> Has anyone got any expericence with MS Access Data/Time Field which >> uses Numbers instead of dates and combines both date and time into a >> single numeric expression. >> >> How can we, when using xbase++ both access and write back to this data >> as you may recall 0 is expressed as 12/30/1899 12:00:00 AM >> >> I need this access for the MS MAPPOINT integration where the StartTime >> property makes use of this setting and requires a date field only. >> >> What do what have in Alaska that can look like a date field yet >> provide this functionallity for Microsoft. >> >> Any help would be great appreciated. >> >> Thanks >> >> Chris >> Kelowna BC Canada >> >Hello Chris, >for MS Mappoint i use > >static function D2DT(vdat, vtim) >return >str(year(vdat),4)+"-"+strzero(month(vdat),2)+"-"+strzero(day(vdat),2)+" >"+vtim+":00.000" Thank you very much it worked 100 %, I can now set the start time any where i need to. Greatly appreciated Wolfgang. Best Regards Chris |