Date and time in one

Business Central/NAV Developers Forum
1

Hello, Has anyone been able to put a date into MS Outlook without using an OCX? The problem is as following: MS Outlook needs a date and time in one. Navision has seperated date and time types. Anyone? Anolis Sittard Netherlands

2

Try this file, it is from Navision and converts Navision date time into VB date/time format. DateTimeConverter.zip I have no further documentation of it, but it seems to be pretty simple with only 4 methods:


GetStart(VAR IDISPATCH pItem, VAR BSTR DateValue, VAR BSTR TimeValue)
SetStart(VAR IDISPATCH pItem, VAR BSTR DateValue, VAR BSTR TimeValue)
GetEnd(VAR IDISPATCH pItem, VAR BSTR DateValue, VAR BSTR TimeValue)
SetEnd(VAR IDISPATCH pItem, VAR BSTR DateValue, VAR BSTR TimeValue)

Please post if any problems occur. Soren Nielsen, moderator Integration/Developer NOLUG

3

Ok here goes a small example:


OutlookApptmnt := Outlook.CreateItem(1);
DateText := FORMAT(TODAY);
TimeText := FORMAT(TIME);
DateTime.SetStart(OutlookApptmt,DateText,TimeText); 
OutlookApptmt.Location := Prospect.Name + ' ' + Prospect.City;
OutlookApptmt.Subject := Prospect.Description;
OutlookApptmt.Save;

Hope this works for you. Soren Nielsen, moderator Integration/Developer NOLUG

4

It works, perfect! Do you know if this OCX is freeware? I mean, can I just use it anywhere, anytime? Anolis Sittard Netherlands

5

I think it is… but let me find out for sure. Soren Nielsen, moderator Integration/Developer NOLUG

6

Just got at go from Navision DK, it is FREEWARE. So use for whatever you desire :slight_smile: Soren Nielsen, moderator Integration/Developer NOLUG

7

Thank you very much for your time! Anolis Sittard Netherlands