select day and input text

Kevin

Hello,

 

I tried to  write "test" on Status column when date is 26. so I first get day from time column and write the follow script, but it doesn't work. Can someone take a look what's wrong with my script

Time	date	Status
06/26/2018 1:46:50 PM	26
06/27/2018 2:30:09 PM	27
06/28/2018 4:13:20 PM	28

 

sdt=current data table();

sdt << selectwhere (:date ==day(26) );
selRows = sdt << getselectedRows;
Ascolumn (sdt, "Status")[selRows]="test";

txnelson

You are taking the Day() function of 26, and what you want to do is to take the Day() function of the :Date column.

sdt = Current Data Table();

sdt << selectwhere( Day( :date ) == 26 );
selRows = sdt << getselectedRows;
As Column( sdt, "Status" )[selRows] = "test";