community
cancel
Showing results for 
Search instead for 
Did you mean: 
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Interactive Lessons
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Calculations with Dates and Times

Sr. Instructional Designer
Sr. Instructional Designer

Lesson Objective: Perform calculations on Date and Time data types.

Estimated Time: ~12 Minutes

Description:

  • Learn about the Date, Time and DateTime data types and how they can be used in the Formula tool's configuration
  • Explore commonly used DateTime functions to add an interval of time to a date and calculate the difference between two DateTime values
  • Challenge yourself with a quiz!

Recommended Follow-Up: Preparing Data with String Functions, Using Numeric Functions

Comments

There are moments during this lesson where there is no audio, and then the lesson suddenly jumps to a different topic. 

Sr. Instructional Designer
Sr. Instructional Designer

@salcantara My video seems to work just fine.  The video is streaming, so you'll want to make sure your internet connection is strong. 

Meteor

Good explanation, thank you !

Atom

 How do we know which specifier to use , do we have the list of specifier to remember 

Bolide

Hello @Ram21 - There is a detailed page on which specifics to be used. With it will come naturally to you.

 

https://help.alteryx.com/current/Reference/Functions.htm#Date/Time

Atom

Hello 

Comet

The audio is very quiet on this one, and also couldn't you just write one expression for the Days to Maturity part, by saying DateTimeDiff([Maturity Date],DateTimeNow(), "days")?

What is the answer to the activity in this video? Can anyone explain the solution for the activity, please!!!

Atom

@chandana10494

 

Data Type the activity is looking for is DATE - which is a 10 character String in "yyyy-mm-dd" format

 

https://help.alteryx.com/2018.2/Reference/DataFieldType.htm

 

Meteoroid

I encounter these very interesting artefacts along the videos. Refreshing the page is not changing anything....

Capture4.PNG

 

Atom

How to solve the statement below?

a ten digit data type that would be a suitable output for a Data TimeAdd function

 

Thanks!