join variable values

Grantx · 2021-01-10T19:30:00+00:00

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.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
01/10/2021 at 8:30 PM #157235 quote

Grantx
Participant

Average

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.

01/10/2021 at 10:39 PM #157243 quote

robertogozzi
Moderator

Legend

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!

01/10/2021 at 11:58 PM #157250 quote

Grantx
Participant

Average

ok, so no way to concatenate?

Is there tostring() functionality or similar?

01/11/2021 at 1:17 AM #157253 quote

robertogozzi
Moderator

Legend

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

Grantx thanked this post
Author

Posts