DSXchange

I have dates in the following format coming in as source data:
YYYYDDD. Where ddd= the day of the year. When I output these dates to our warehouse I know I will have to convert them, but I also have values of 0 in these fields which I would like to convert to null. Is there anyway to do this in PX with a date datatype? The target is an Oracle database.

Thanks.

seanc217 wrote:I have dates in the following format coming in as source data:
YYYYDDD. Where ddd= the day of the year. When I output these dates to our warehouse I know I will have to convert them, but I also have values of 0 in these fields which I would like to convert to null. Is there anyway to do this in PX with a date datatype? The target is an Oracle database.

Thanks.

Try to handle this using function conbinations like:
If ('yyyyddd'[3])='000' then setnull() else DateFromDaysSince()

IHTH

It looks like this will work well.

Thanks!!!!