IF OFFSET >=0 THEN
TIME_LOCAL:= ((current_time + OFFSET)>24) ? ((current_time + OFFSET) - 24) : (current_time + OFFSET);
else
TIME_LOCAL:= ((current_time + OFFSET) < 0) ? ((current_time + OFFSET) + 24) : (current_time + OFFSET);
endif;
Asked
Active
Viewed 71 times
-6
-
This isn't legal VBA... or VB.NET. What language is this? – Mathieu Guindon Aug 19 '16 at 14:51
-
In **VBA** the `?` token is a shortcut for the `Print` instruction (which is equivalent to `Debug.Print`), and the VBE (the editor) automatically changes `?` to `Print`; the `:` token is usually an *instructions separator* and is used to combine multiple statements on the same logical line of code, e.g. `For i = 0 To 100 : Debug.Print i : Next` - when used immediately after an identifier at the start of a line, it denotes a *line label*, e.g. `CleanFail:`, which can be used in `On Error` statements, e.g. `On Error GoTo CleanFail`, or simply with `GoTo` statements. Lines don't end w/ `;` in VB. – Mathieu Guindon Aug 19 '16 at 15:08
1 Answers
2
The conditional operator (?:) returns one of two values depending on the value of a Boolean expression. Following is the syntax for the conditional operator. condition ? first_expression : second_expression;
Jpad Solutions
- 332
- 1
- 12
-
That's the *ternary* conditional operator, and it's not legal in VBA. – Mathieu Guindon Aug 19 '16 at 14:50
-
1Yes, I agree. That code is not VBA. The tag needs to be changed. Which I cannot do. – Jpad Solutions Aug 19 '16 at 14:52
-
I could, but apparently [there's no such ternary operator in VB.NET](http://stackoverflow.com/q/576431/1188513), so I don't know what language this is. – Mathieu Guindon Aug 19 '16 at 14:54
-
I would guess C# that has been messed around with before posting. Maybe the OP could enlighten us – Jpad Solutions Aug 19 '16 at 14:55
-
Whatever the language, it's a ternary operator. Have an upvote =) – Mathieu Guindon Aug 19 '16 at 14:57