AnsweredAssumed Answered

Empty Date from SQL Server

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

Hi,

 

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?

 

Thanks,

Vamshi

Outcomes