Adding DateTime filter

Hi All,

I have a column which shows the date+time of the last modification of the Logistical Status as can be seen on the below iamge:
image

I wish to filter all lines which are modified 2 days ago, however I get the below error when filtering T-2d.
"The filter “T-2d"is not valid for the Logistical Status Last Modified on Field. The value “T-2d” can’t be evaluated inty type Datetime”

Is it possible to filter all lines which are 2 days prior to today, or does the Column needs to be changed to date only for this to work?

Nick

Filtering a datetime field - Dynamics 365 Business Central/NAV User Group / Developers Forum - Dynamics User Group

Just use the CREATEDATETIME function.