Alaska Software Inc. - Need Help with ActiveX and MS Access Date/Time Field
Username: Password:
AuthorTopic: Need Help with ActiveX and MS Access Date/Time Field
Chris ChambersNeed 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 CiriackRe: 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 ChambersRe: 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