Querying a Julian Date column

[Soxfaninfl]

I need to query the last 30 days when my workflow runs daily. I need the syntax that will allow me to query a Julian date column that is in the integer 64 format. The column is called "current date". I tried the following syntax, but that didn't work.>= date_add('day',-30,Cast(now() as Date)).

This works, but I don't want to have to set a specific date "current_date" >= 121225. I want to always query the last 30 days when my job runs.

[Thableaus]

Hi @Soxfaninfl 

Quick question - Are you using In-Database tools or regular tools? Could you take a quick screenshot of your workflow?

If you are using the regular tools, check this post by @RolandSchubert - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-from-julian-date-from-JD-Edwar...

He provided a way to easily convert these dates. 

Cheers,