140370 - no subject - I have a task report where i need to cap

vahedullas1000

A Score Level 1

over 9 years ago

I have a task report where i need to capture the tasks 12 PM today or earlier day. I am not sure which function needs to apply for calculating 12 PM. Applying the below function returning the yesterday's tasks.
{field:"8",operator:"LESS_THAN",value:today()-1}
Thanks in advance.

Discussion posts and replies are publicly visible

0 Tim
Certified Lead Developer
over 9 years ago

Try using the datetime() function to manually calculate the value
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vahedullas1000
A Score Level 1
over 9 years ago

Can you please share me the peace of code.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 9 years ago

=with(
local!day: today()-1,
local!targetDate: datetime(year(local!day), month(local!day), day(local!day), 12, 0, 0),
a!textField(
value: local!targetDate
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rupeshc over 9 years ago

You can try creating a constant(for example TEST_TIME) with the value as 12 PM EST/IST and then use that constant to find the desired time like: today() &" "&cons!TEST_TIME
Store that into a variable and you will get the desired date, which is in your case is 12 PM for today, to fetch the tasks by using that variable.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel