Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Passing Blank value to Date field in BDC

Former Member

‎04-24-2009 8:29 AM

0 Kudos

Hi,

I want to pass blank value to Date field in BDC, I am using Batch input to upload data, while doing this if i pass blank value to date field the date will get calculated automatically.

The issue is if i am passing space to that field which is of type DATS, by default it is taking ' . . ' and throwing error. I want absolute blank so that date will calculated automatically.

I cant change the field type, it is DATS. If it is CHAR it will work how to handle with DATS.

3 REPLIES 3

Former Member

‎04-24-2009 8:34 AM

0 Kudos

Hi,

Try passing value '00:00:0000' as this the initial date value.

Hope it helps,

RJ

Former Member

‎04-24-2009 8:42 AM

0 Kudos

Hi Phanindra,

Just pass the zero value in dats format ie 00:00:0000 or even YYYYMMDD format and your BDC will work fine.

Former Member

‎06-17-2009 10:51 AM

0 Kudos

We can pass only if the field is of type CHAR.

Edited by: Phanindra Annaparthi on Jun 17, 2009 11:51 AM