topic Re: Change dates in Load in App Development

Change dates in Load

Meg00 — Mon, 30 Sep 2019 12:44:56 GMT

Hello!

I am loading a table with two dates, "startdate" and "enddate".

The problem here is that the rows that should have null value in "enddate"(rows where an end date really doesnt exist) is set to 1900-01-01 and this is now messing up my calendar obviusly. Is there a way to make every "enddate" with that specifik date set to null?

Thanks

/Meg

Re: Change dates in Load

teiswamsler — Mon, 30 Sep 2019 13:57:47 GMT

Hi Meg

You change the date.

If( enddate = '1900-01-01', null(), enddate ) as endate.

But nowyou cant select the null() enddates

Br.
Teis

Re: Change dates in Load

jonathandienst — Mon, 30 Sep 2019 14:06:27 GMT

It would appear that the value is neither null, nor zero. A date of 1900-01-01 is a number greater than 0 and less than or equal to 1. if there is no time component, then 1900-01-01 == a value of 1.00. You could force these values to null during your load -- something like

LOAD ...
If (startdate < MakeDate(2019), null(), startdate) as startdate,
...