62666_en-US

liliconcom

select day and input text

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";

Re: select day and input text

What you show will work....with one slight change.....you need a ";" after X1 = 26

X1 = 26;

Re: select day and input text

Thank you, it works! Another question, if I would like to set 26 as vaiable, 

x1=26
sdt << selectwhere (Day(:date) == x1 );
selRows = sdt << getselectedRows;
As column (sdt, "Status")[selRows]="tested";

 

Does this look right?

 

 

Re: select day and input text

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";