We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unix (Epoch) Timestamp

OriginalAdrian
7 - Meteor

Hi Community,

 

Does anyone have a way to obtain an Epoch timestamp?

 

"Count the seconds since 1970"

 

Thank you!

6 REPLIES 6
OriginalAdrian
7 - Meteor

I should note that I am trying to accomplish Oauth 1.0 authentication with an API. I can recreate some existing Oauth2.0 connectors when needed but this 1.0 one is proving to be a problem. 

 

The API requires a hashed signature that I need Unix time to create. 

 

If anyone has an example of OAuth 1.0, not 2.0 signature creation I would greatly appriciate it!

RodL
Alteryx Alumni (Retired)

Not sure about the Oauth questions, but the expression to get the number of seconds since 1/1/1970 would be...

 

DateTimeDiff(DateTimeNow(), '1970-01-01', 'seconds')

 

You'd probably need to adjust for your time zone.

OriginalAdrian
7 - Meteor

Much appriciated Rod 

Sudharshan_Sannathi
6 - Meteoroid

Thanks a lot @RodL . This saved me lot of time.

MLRM
6 - Meteoroid

This is probably simple but how do I incorporate this formula with some other text in the same column. See below: 

 This way works: 

MLRM_0-1624576718488.png

This way does not: 

MLRM_1-1624576739265.png

How do I get it to work in the second formula. Probably just a small error in syntax or data type mismatch. 

 

Thanks, 

Marshall

 

Scott_Snowman
10 - Fireball

In case anyone else stumbles across this while searching or @MLRM never got resolution:

 

Based on the screenshot, the [Count] field is most likely an integer data type.

 

Use ToString([Count])to be able to concatenate it into a text expression as desired.

Labels