AnsweredAssumed Answered

Empty Date from SQL Server

Question asked by vvelpula087283 on Nov 2, 2017
Latest reply on Nov 4, 2017 by



SQL server datetime column stores 19000101 whenever there is no input into that field (empty input). In Boomi, when querying a row with that column the value retrieved is '19000101 000000.000'. I have a mapping that would in general map this to a destination field to an outgoing XML document. However, when the value is as mentioned above, I don't want the mapping to 'work' i.e., pass this value. How do I do this? I have tried to add a custom javascript scripting function in my map that compares the field on the incoming document to null, '19000101 000000.000' etc and neither is working. 


Any ideas please?