Working with Dates

Clinton Jones
Clinton Jones Experian Elite
edited December 2023 in General

I have a set of data that contains some dates

image.png

What I would like to do, is split the day, month and year into their own columns, this is easily done with the TRANSFORM step and using the EXTRACT TIMESTAMP ELEMENT date functions - there are many options available here

image.png

If you want to determine the elapsed time between today and that date you are comparing with you would use the CURRENT TIMESTAMP DYNAMIC function and the COMPARE DATE TIME function

image.png


If I want more precision or rounding then I can use the ROUND function

image.png


image.png

My data for other filtering or calculations then looks thus

Tagged:

Categories