Set Activity start and end time in hours

Completed

Scott Cox

• April 18, 2019 15:04

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.

Vote

3

• 

  SSP Automation

  • April 21, 2019 21:18

  Thank you for your request.
  The development team have now added it to our internal planning-system for evaluation.
  [Internal Id: 22845]
• 

  Rasmus Jensen

  • May 30, 2020 21:24

  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)
• 

  Diego Sanchez

  • April 13, 2022 03:19

  Hello,

  Do you have any example for Hana?

  Thanks.
• 

  Rasmus Jensen

  • April 15, 2022 08:53

  Not as such, but if you just write a HANA sql that give the date back in yyyy-MM-dd format it should work…
• 

  Diego Sanchez

  • April 18, 2022 18:10

  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.

   
• 

  Rasmus Jensen

  • April 19, 2022 06:24

  If you can make the SQL give format yyyy-MM-dd@Hmm it should work... 
• 

  Diego Sanchez

  • April 20, 2022 15:54

  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.