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.
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!
ok, so no way to concatenate?
Is there tostring() functionality or similar?
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