Hello,

The node below queiries data with a data column which has a format of MM/DD/YYYY. Lavastorm seems to populate the data as MM/DD/YYYY 00:00:0000 with the output of the node. We believe we get errors from the WHERE statements in the node becuase the where statements are built to filter for MM/DD/YYYY. Is there a way to ensure that the data from the date column is aquired as MM/DD/YYYY during aquisition? The second question is there a way to write the filtering to accomodate both formats?

Or should we have the user convert those basic nodes to core:DB Query nodes?

Thanks

node:West_EDW_OCC
bretype:basic::querydump
editor:Label=West EDW OCC
editor:sortkey=4b758947121608f8_9
output:@40fd2c7444283da6/=
prop:DBInterface=cli
prop:DBService=cnewp.sbc.com
prop:DBUser=xxxxxx
prop:QueryFile=<<EOX
select *
from access.v83b10
Where cabs_bill_date between '01/10/2015' (date, format 'mm/dd/yy')
and '11/30/2015' (date, format 'mm/dd/yy')
and ban = '0730960566777'
and service_order_number = 'C78883305'
--and phrase_code = '759'
--and service_order_comp_date >= '20110726' (date, format 'yyyymmdd')
--and from_date >= '20110421' (date, format 'yyyymmdd')
--and phrase_code in ('M63','M64','032','033')