join variable values

• 01/10/2021 at 8:30 PM #157235
  Grantx

  Is there a way to join date time values together? eg

  mydateopen = OpenDate + OpenHour

  mydateopen = OpenDate & OpenHour

  Neither of these work. For each day I have specific session times so need that days first bar opening time and last bar closing time.

  

  Grantx

  Participant

  Topics: 23

  Replies: 23

  Been thanked: 3 times
  01/10/2021 at 10:39 PM #157243
  robertogozzi

  Try that on a pocket calculator:

  OpenDate  20200110 + Jan.10th
  OpenHour               23 = 11pm
  .                    20200133 =Jan.33rd

  Your second example uses a logical operator with numbers, can’t work!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16465

  Been thanked: 3641 times
  01/10/2021 at 11:58 PM #157250
  Grantx

  ok, so no way to concatenate?

  Is there tostring() functionality or similar?

  

  Grantx

  Participant

  Topics: 23

  Replies: 23

  Been thanked: 3 times
  01/11/2021 at 1:17 AM #157253
  robertogozzi

  No, they are considered as numbers, so you need to shift them by multiplying them.

  Adding, say, 1 year to a date is possible, but you have to multiply 1 by 10000 to skip days and months:

  date  20210111 +
  year         10000 =
  .          20220111

   

  1 user thanked author for this post.

  Grantx

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16465

  Been thanked: 3641 times
• Author
  Posts