How to use today()-1 date filter in SAS Data Studio plan

[SatishR]

Dear Team,

I am trying to filter out the Yesterday's data from Audit table and I want to store in Historical manner in my permanent lib. However I am not getting any option to filter out data in dynamic way. I have attached screenshot for your reference.

Any option to filter out data based on today()-1 features. Kindly assist me regarding the same.

Thanks in advance.

[LinusH]

I don't have Data Studio at my fingertips, and the docukentation is not really answering this specific need.

But your screen shot is from the Convert Column transform, please attach one with the Filter transform.

[SatishR]

@LinusH  kindly find the below screenshot

I think this can be achieve using custom code

[LinusH]

Ok, so the question is what kind of expressions are valid in the Value field.

I guess you can try your today()-1 or "&Sysdate"d-1.

[SatishR]

@LinusH Using below custom code we can achieve the scenario

This resolved the concern.

Thanks for your support.

[Patrick]

@SatishR Instead of custom code you could also use the BETWEEN operator from your dropdown list to generate the following where expression:

datetime between intnx('dtday',datetime(),-1,'b') and intnx('dtday',datetime(),-1,'e')