String to date conversion in SWQL

Ah - I see what you are doing.  Remove the quotes from inside the DateTime() Function.

SELECT DateTime(UDCP.CurrentValue)

Well, function is not recognized

Do you get the same error if you send over:

SELECT [UDCP].CurrentValue AS [Date as Stored]
     , [UDCP].Node.Caption AS [Node Caption]
     , DATETIME([UDCP].CurrentValue) AS [Date as Date]
FROM Orion.NPM.CustomPollerAssignment AS [UDCP]
WHERE [UDCP].CurrentValue != 'Unknown'

That picture above isn't SQWL Studio, it's the database manager.  Try in SWQL Studio.

Oh sorry. Still the same:

Very odd.  How about if you run:

SELECT TOP 1000 Name
FROM Metadata.Functions
WHERE Name LIKE '%Date%'

This will get the list of valid functions for the API.

Also, if I didn't ask, what Orion Platform version are you running?

KMSigma.SWI said:

Orion Platform version

2020.2.6

Well, that function is certainly available.  Odd.  I don't have any CustomPollers in my lab that return MM/DD/YYYY, so I don't have an easy way to test these out.

Last check - maybe the CurrentValue is some off format.

SELECT [UDCP].CurrentValue AS [DateAsStored]
     , [UDCP].Node.Caption AS [Node Caption]
     , DATETIME(ToString([UDCP].CurrentValue)) AS [DateAsDate]
FROM Orion.NPM.CustomPollerAssignment AS [UDCP]
WHERE [UDCP].CurrentValue != 'Unknown'

If that fails, then we need to make sure the rest is ok.

-- Commenting out the conversion
SELECT [UDCP].CurrentValue AS [DateAsStored]
     , [UDCP].Node.Caption AS [Node Caption]
--   , DATETIME(ToString([UDCP].CurrentValue)) AS [DateAsDate]
FROM Orion.NPM.CustomPollerAssignment AS [UDCP]
WHERE [UDCP].CurrentValue != 'Unknown'

If the first works, then great!  If not, can you save the results of the second a CSV and attach them?

KMSigma.SWI said:

Last check - maybe the CurrentValue is some off format.

Same error here :<

KMSigma.SWI said:

If that fails, then we need to make sure the rest is ok.

How can I send the results to you in more private way?
Not sure if Thwack has a PM function Lol found it. Just a min.
Oh, you are not messagable :< Cannot Message

We have to be Friends first.  It's explained in the THWACK documentation [Creating Content].