InaPlex Forums

I am having trouble inserting Empty Date values into GoldMine 7 running on MS SQL Server

I have used the Add Fields tab in Inaport 7 to convert the date values from my Access Database to a format that GoldMine understands, but I cannot work out how to make the goldmine field empty when the source field is NULL. I have tried the following:

d2s(#DOB, "dd/MM/yy")    - This gives an error on NULL dates in my source #DOB field

iif(isnull(#DOB),"",d2s(#DOB, "dd/MM/yy"))    - This inserts the current date for some reason

iif(isnull(#DOB),NULL,d2s(#DOB, "dd/MM/yy"))    - This also seems to insert the current date into goldmine.

Any Ideas??

Thanks

Russell

Hi Russell

Inaport uses the GoldMine API to write to GoldMine, and thre is no way it can write a NULL value.

The best would be to tick the "Skip if source blank" checkbox in the field map - that way, if there is no value in the date field you are mapping, Inaport will not attempt to write it and nothing will be written to GoldMine.

Regards

David

Hi David

That has done the trick - thanks for that

I can't believe that the GoldMine API does not allow you to set empty dates though! How would you go about clearing out a date field???

Russell

You can't, at least through the API.. :-)

Regards

David