Date coming in as number when going from Quickbase to Alteryx

[Tori-Tiesenga]

Whenever I take a report from QuickBase that has the date formatted as dd/mm/yyyy to Alteryx, I end up with a number like 1698019200000. Does anyone know why? I've tried to change it to a date without any luck. What am I doing wrong?

Thank you in advance!

[AGilbert]

If you have a date as a string datatype you can use the datetimeparse() function to convert it to a date datatype. Alteryx only recognizes dates in the yyyy/mm/dd format. 

Regarding the long string of digits, it would be helpful to see the source data and workflow that is giving that value. 

[Noel_Wiedner]

I'm having the same issue.  Hoping someone here posts a solution!

[apathetichell]

convert the large number to a number (if stored in string). divide it by 1000.

try:

datetimeadd("1970-01-01",[your new number],"seconds")

as a new date or datetime field. Does this look right?

The original post looks like it was 2023-10-23 00:00:00

@Tori-Tiesenga - sorry I didn't address your question when you posted. Hopefully this is what you wanted.

[Noel_Wiedner]

That did the trick for me!  Thank you SO much.

In all my days, I'd never have guessed that Quickbase (apparently) stores dates as number of milliseconds elapsed since New Year's Day 1970...huh.

[apathetichell]

https://www.unixtimestamp.com/

[Noel_Wiedner]

Fascinating - thank you!