INTNX function

[albribmun]

Hi,

I would like to be able to select data where the 'send date' of my dataset refers to the last 3 weeks from today.

Thanks.

[Quentin]

Hi,

Please show what code you have tried, and describe why it didn't work (did you get an error? did you get a surprising result?).

Also, please define your selection criteria more precisely.  Do you want to select all records where FECHA_ENVIO is within 21 days of today's date (the date the program is run)?

Perhaps:

if (today() - datepart(fecha_envio)) <=21  ;

[Reeza]

where fecha_envio > intnx('dtweek', today(), -3, 'b');

Thinks you should consider - what defines a week? Is it 21 days before exactly or does it start on Sunday's? Does it start at the same times as when you run the report (e.g 10:23) or is at the start of the day (00:00)? You control these choices with the first and last parameter in the INTNX function.

[albribmun]

I have executed the command you say and it does not give me an error but it does not give me the expected result.

[Reeza]

intnx('dtday', today(), -21, 'b');

Try that one instead

[Kurt_Bremser]

The datetimes you show are ALL before three weeks before today.

[albribmun]

Not all

Log:

[Kurt_Bremser]

---

@albribmun wrote:

Not all

---

And as your log tells you, 885 observations met the condition and were read and written to the new dataset.

Please do not post pictures. Copy/paste log text to a window opened with this button:

To supply example data for our use in developing and testing code, use a data step with datalines, and post it as text in a window opened with the "little running man" right next to the one indicated.

[Tom]

Note that TODAY() is just an alias for the DATE() function.

So the function TODAY() returns a DATE value (number of days since 1960).

The DTDAY interval works with DATETIME values (number of seconds since 1960).

If you treat the number of days since 1960 as the number of seconds since 1960 you get some time early on January 1,1960.

If you want the current datetime value use the DATETIME() function.

[albribmun]

Yes, I want to get all records for all other variables where the date is between the last 3 weeks. The code does not give me error, but the table is not displayed.

[Quentin]

Can you show the log? It should show the number of records read in, and the number of records written out. It may also show errors, warnings, or bad notes.

[albribmun]

I have already found the solution using this: 

if intck('week', today(), datepart(fecha_envio)) ge -3