SOLVED
Invalide Type in Operator
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AC3
5 - Atom
‎01-23-2020
09:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm getting a "Invalid type in operator >=" when trying to create a simple condition
iif([Right_u_start]>=[u_start]&&[Right_u_start]<=[u_end_date],"True","False")
Solved! Go to Solution.
Labels:
- Labels:
- Tips and Tricks
2 REPLIES 2
Thableaus
17 - Castor
‎01-23-2020
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AC3
You need to check for data types. Fields can be only compared if they have same data types (string, numeric, dates, etc.)
Cheers,
MarqueeCrew
20 - Arcturus
‎01-23-2020
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator