data types question

[Filter300]

Ok.. i have a VB program the writes data out to a lotus Notes Database, now when i write my date fields out to the notes DB the data type changes to a string... cuz for some reason VB Date and Notes Date are different and not compatiable...
when the field is written the property of the field is changed from DateTime to liststring and this causes all kinds of problems for our notes programs.... so to get to the point here.... anyone know how i would make a datatype in vb that would be compatible witht the Notes Datetime??? or am i just S.O.L. ?????

[kleinma]

COUGH MS ACCESS COUGH

M$ just has that mystical way of making everything easier when you use all their stuff

[Filter300]

yeah.. see thats the problem... this program takes data from an access database and loads it into a notes database... Believe me, if it were up to me.. it would all be access db's, notes db's sucks! they are slow and very hard to work with.... so any other idea's? the only thing i can come up with is when my program finishes kick off a notes script that would then go back thru and change the data type to datetime again... but that seems like over kill... i shouldnt have to proccess this thing twice....

[Filter300]

any ideas¿¿¿

[Filter300]

well i got this to work if anyone wants to know....

i had to create a notes session and thru that session create a datetime field then load that field to the database....


Dim DomSession As New NotesSession
Dim itemz As NotesItem
Dim itemy As NotesItem
Dim itemx As NotesItem
Dim datetime As NotesDateTime
DomSession.Initialize (Password)
Set datetime = DomSession.CreateDateTime(strdate)
Set itemy = appDoc.ReplaceItemValue("ExpirationDate_BXAANB", datetime)