Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

SQL assertion with date fields 

Thu March 26, 2020 04:35 PM

Forum question posted - 

I am trying to do a sql assertion to compare a date field to the results of my sql statement.  In debugging, it looks like the date fields are coming back in different formats, so it's saying they aren't equal here.  What's the best approach to comparing date fields in an instance like this?

 

{"index":69,"event":"assertAttributeTrue","id":"m6858fd2-tb","attribute":"value","value":"sql: select schedstart from maximo.workorder where wonum='{$wonum}'","comment":"check dates"}

 

m6858fd2-tb is the required date on a material line.



Response - 
I tried capturing the Scheduled Start date as a variable and doing an assertion on the required date comparing to the variable value instead and it seemed to work.



#AssetandFacilitiesManagement
#MaximoEAM
#Maximo

Statistics
0 Favorited
2 Views
0 Files
0 Shares
0 Downloads