Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
4 subscribers
Views
1719 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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.
OriginalPostID-140370
Discussion posts and replies are publicly visible
Parents
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
Reply
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
Children
No Data