current day logic

[soniasweety]

Hi all,

Antonio Mancini

I have a scenario like below  attached with sample data and with example.

and how can set the day of the week  ?  how to this in scripting?  and in  front end how to approach?

Thanks

Sonica

[d_prashanthredd]

If so, use one more condition like len(trim(assignedto))=0 along with days condition or you can use...

if(len(trim(assignedto))=0, 'Expression i.e. the one which used for days')

[antoniotiman]

If(IsNull(Assignedto),YourExpression)

or If(Len(Trim(AssignedTo))=0,YourExpression)

However, can You provide new Input Data ? (modified Excel File)

[d_prashanthredd]

More Info on Now and Today.. I hope it will help you, so that you can decide what to use.

now( [ timer_mode] )  ---- timer_mode: 0, 1, 2, default

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

0 Time at script run
1 Time at function call
2 Time when the document was opened

Default timer_mode is 1. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

today( [timer_mode] ) ---- timer_mode: 0, 1, 2, default

Returns the current date from the system clock. The timer_mode may have the following values:

0 Date at script run
1 Date at function call
2 Date when the document was opened

Default timer_mode is 2. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

So now(), now(1) and today(1) all refresh every second, and should be used with caution.

[soniasweety]

yes exactly

[soniasweety]

Hi Sir,

attached updated excel with new column assigned to --- display above criteria where assignedto value is null only/

[antoniotiman]

See Attachment

[soniasweety]

Hi Sir,

Could you check is this logic will work for my requirement?   or will I do any changes?

[antoniotiman]

This is different logic.

It seems same result.

I don't see IsNull(assignedto)

[soniasweety]

Hi,

Now check the app with correct result . which is working fine.     [forgt null I worked in real app null is also working]

for your testing just change in inline

load * Inline [

currentday,limit

1,5

2,5

3,5

4,3

5,5   ----- this

6,4

7,5

];