Error Messages in Interface Tools with Dates

[ddiesel]

I have an app that allows users to query a SQL Database. The user is permitted to enter start and end dates (as well as other criteria). The particular table I point to only includes current year data so I want to restrict the user to only select dates in the current year.

With this formula, I get an invalid type in operator message:

[#1]>2016-12-31

This formula does not restrict the date:

[#1]>'1-january-2017'

What is the right formula for this use case?

[MarqueeCrew]

@ddiesel,

Hi :)

'2016-12-31' represents a STRING.  All dates are STRINGS.

[#1] > "2017-01-01"

Try that please.

Cheers,

Mark

[ddiesel]

Hello! @MarqueeCrew... fastest draw in the galaxy!

Configuration:

Error message:

[MarqueeCrew · Accepted solution]

https://meetings.webex.com/collabs/meetings/join?uuid=MBK0HP925LDF6B3CPY90DGIBP5-UCSL&epwd=fde19b0a0...

[MarqueeCrew · Accepted solution]

to find this year,

Left([#1],4) != '2017'

That will error for other years.

Cheers,

Mark

[ddiesel]

Solution from @MarqueeCrew

Left([#1],4) != "2017"

Thank you!