Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

floor and ceil date time more than 24 hrs

Highlighted
7 - Meteor

Please find the attached workflow given by @jdunkerley79 in https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Time-Rounding/m-p/37037/highlight/fals....

I have 2 different datetime columns for which i need to perform 10 mins round off with floor and ceil option. How can i incorporate that into the attached workflow?

 

Thanks in advance!

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi Newbie,

 

To me it's not quite clear what you are looking for. Could you please provide some example input data and what your desired output from that data would look like.

 

Ben

Highlighted
13 - Pulsar

 

In the first Formula tool, change Minutes + 60 * Hours to one of the following:

 

Floor:

FLOOR((Minutes + 60 * Hours)/10)*10

Ceiling:

CEIL((Minutes + 60 * Hours)/10)*10

Hope it helps!

Labels