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.
Dates in PX
Moderators: chulett, rschirm, roy
Re: Dates in PX
Try to handle this using function conbinations like: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.
If ('yyyyddd'[3])='000' then setnull() else DateFromDaysSince()
IHTH
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.