I am very very new to DS. I am trying to find max of a date column and a time column. when i tried to find the max date using aggregator transformation. i get the below mentioned error.
Well, after my further analysis i could find that there is no direct type cast between Date and dfloat. so, the i could figure out 2 ways to achieve my goal.Error when checking operator: When binding input interface field "XXX" to field "XXX": No default type conversion from type "time" to type "dfloat".
Error when checking operator: When binding input interface field "YYY" to field "YYY": No default type conversion from type "date" to type "dfloat".
1st: to convert the date to dayssincedate, when i try to do that i get the below error. However, to achive this conversion i am not able find the function. could any one out there help me pleaseeee???
2nd way is to convert the date field to integer and from integer to float.
APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "CCYY-MM-DD" for conversion "int32=days_since_from_date[**********](date)": APT_Conversion_DaysSince_Date: Invalid Date [CCYY-MM-DD] used for days_since_from_date type conversion.
to achieve both the solutions i need to figure out the function that i can use in a transformer(or any other stage) to type cast.
Thanks in advance to let me know the solution for this, Also, if there exists any other easier way to fix this issue please let me know.
Thanks again,
Waseem