Date Time Issue

Can you try the below expression:
hour(totime(local(now())))

Hi Vimals, This method works. I am able to extract the correct hour, however to change it back to date time, I am using the datetime() function and providing the hour I extracted before, but it is changing to a different value
now():9/8/2016 4:26 AM EDT
hour(totime(local(now()))):4
datetime(year,month,day,hour,min,sec):9/8/2016 12:26 AM EDT
local(datetime(year,month,day,hour,min,sec)):9/7/2016 8:26 PM EDT
todatetime(local(datetime(year,month,day,hour,min,sec))):9/7/2016 8:26 PM EDT

It seems that hour function is not working with datetime time stamp however it accepts time/datetime as per the documentation and also it seems that hour function is working if just time is passed to it
Can you try the below expression
hour(
text(
now(),
"hh:mm:ss"
)
)

It's not just the hour function, any random hard coded value is also changed to a different time in the datetime function. For eg.,
datetime(2016,9,8,4,30,30,30) returns 9/8/2016 12:30 AM EDT

Please have a look at the documentation to understand how appian handles date and time. forum.appian.com/.../Date_and_Time_Functions.html

Thanks, I guess userdatetime() solves the issue :)