06-26-2016 04:45 PM
06-26-2016 08:26 PM
There's an operator called 'Adjust Date' which is very simple to configure.
Select the attribute you want to adjust, select the unit you want to add(or subtract) in this case minutes, next type in the adjustment value.
For more complex calculations or to convert your hour column if it is stored as nominal then the Generate Attribute operator is your friend. Here you can type something like:
date_str_custom( date_add( date_parse_custom(myTimeAtt,"HH:mm"),15,DATE_UNIT_
MINUTE ) ,"HH:mm")
This will convert your nominal value into a date add 15 minutes and then convert it back into a nominal value.
06-27-2016 07:02 PM
I ve got ¨PROBLEM OCCURRED¨ with Adjust Date operator related with the value type of my HOUR att.
But I could make it with generate att n the proposed expression:
Thanks JEdward for your help.