ActiveX Date Type as YYYYMMDDHHMMSS

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
AUGE_OHR
Posts: 1143
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 211 times
Been thanked: 303 times

ActiveX Date Type as YYYYMMDDHHMMSS

Post by AUGE_OHR »

hi,

i try to "read" Outlook Calendar Data and have a Problem while get "only Date" ... not "DateAsString" in YYYYMMDDHHMMSS Format

Code: Select all

  cStringStart := oItem:Start
now i got Start Date but not Time when Appointment start
OL2DBF.ZIP
(3.62 KiB) Downloaded 12 times
need some help please

p.s.
have this "old" HB_FUNC() ... don´t remember what i have used it for

Code: Select all

   HB_FUNC( DATEASLONG )
   {
      PHB_ITEM pDate = hb_param( 1, HB_IT_DATE );

      if( pDate )
         hb_retnl( hb_itemGetDL( pDate ) );
      else
         hb_retnl( 0 );
   }

Code: Select all

   HB_FUNC( DATEASDOUBLE )
   {
      PHB_ITEM pDate = hb_param( 1, HB_IT_DATE );

      if( pDate )
         hb_retnd( hb_itemGetDD( pDate ) );
      else
         hb_retnd( 0 );
   }
have fun
Jimmy

User avatar
AUGE_OHR
Posts: 1143
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 211 times
Been thanked: 303 times

Post by AUGE_OHR »

hi,

found out that i have to set Language to get data as Timestamp :o

Code: Select all

   REQUEST HB_LANG_DEWIN
   REQUEST HB_CODEPAGE_DEWIN
   hb_cdpSelect( 'DEWIN' )
   hb_langSelect( 'DE' )
and use DBF with Codepage UTF8

Code: Select all

   USE ( zDBF ) EXCLUSIVE CODEPAGE "UTF8"
now here working Version
OL2DBF2.ZIP
(3.48 KiB) Downloaded 18 times
have fun
Jimmy

User avatar
AUGE_OHR
Posts: 1143
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 211 times
Been thanked: 303 times

Post by AUGE_OHR »

hi,

there was still a BUG with "Createtime", sorry
OL2DBF3.ZIP
(3.7 KiB) Downloaded 12 times

! Note : have rename to Outlook.DBF / Outlook.FPT

you have to check in Source for your need

Code: Select all

   REQUEST HB_LANG_DEWIN
   REQUEST HB_CODEPAGE_DEWIN
   
   SET DATE GERMAN
   hb_cdpSelect( 'DEWIN' )
   hb_langSelect( 'DE' )
   USE ( zDBF ) EXCLUSIVE CODEPAGE "DEWIN"
   
App for this DBF Structure under Construction ...
have fun
Jimmy

User avatar
AUGE_OHR
Posts: 1143
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany
Has thanked: 211 times
Been thanked: 303 times

Post by AUGE_OHR »

hi,

have change Structure again while have a "OverNight" Problem.
OL2DBF4.ZIP
(3.48 KiB) Downloaded 6 times
so i add Outlook Calendar Property "End" and use a 2nd Label.
hm .. more Problem when move or delete ... :roll:
OverNight1.jpg
OverNight1.jpg (225.82 KiB) Viewed 77 times
have fun
Jimmy

Post Reply