Set Activity start and end time in hours Completed
Currently the only options we have are below, to set a start time.
I am asking for the ability to set a start time in hours from the time it was created, for example the start time would be set for 1 hour after creation, if the activity was gets created at 2pm, the activity start time is 3pm.
Comments
7 comments
The development team have now added it to our internal planning-system for evaluation.
[Internal Id: 22845]
Will be added to 2020.06 Release (Your specific request about one hour from now need to be written via SQL but it should not be a huge issue to write such a SQL)
Hello,
Do you have any example for Hana?
Thanks.
Not as such, but if you just write a HANA sql that give the date back in yyyy-MM-dd format it should work…
Hello,
Is it possible to add our custom time?
I've the next query:
SQL:SELECT (CAST(CURRENT_DATE AS VARCHAR(10)))||'@1100' FROM DUMMY
SQL:SELECT (CAST(ADD_DAYS((CURRENT_DATE),1) AS VARCHAR(10)))||'@1100' FROM DUMMY
But I need the time custom too, I'm trying with query bellow but not work for me, in Hana Studio if it works.
SQL:SELECT (CAST(CURRENT_DATE AS VARCHAR(10)))|| '@'||(SELECT ADD_SECONDS((CAST(CURRENT_TIME AS VARCHAR(5))),60*25) FROM DUMMY) FROM DUMMY
Thanks.
If you can make the SQL give format yyyy-MM-dd@Hmm it should work...
Hi Rasmus,
Thank so much for your reply. The time format was changed ant it works for me.
Please sign in to leave a comment.