Troubleshooting Date Format

[synergy825]

I am having trouble figuring out a Date Format calculation.  The attached workflow was processing fine until this past Wednesday (3/1).  For some reason, it is reading it as January 3 instead of March 1.  It appears the calculation is having an issue when the day is a single digit.  However, it read 3/3 correctly.  I'm assuming it's because the digits are the same.

Here is the calculation formula:

DateTimeFormat(DateTimeAdd('1970-01-01',(tonumber([recordTimestamp])/1000),'second'),'%Y-%m-%d %H:%M:%S')

Below are the dates in the dataset:

I have also attached the workflow as well.  Any help would be greatly appreciated.  Thank you!

[Yoshiro_Fujimori]

@synergy825 ,

I cannot find a problem in your workflow and formula.

How did you check the output .csv file?

If you use Excel, I doubt the wrong date conversion occurred in opening .csv by Excel, due to some local PC setting.

Another thing I am concerned is that you use V_WString type.

It would be safer to use DATETIME type when dealing with timestamp.

[synergy825]

Hi @Yoshiro_Fujimori ,

Thank you for the reply.  I could not figure it out either, but I just created a new instance of Tableau and reconnected to the data output, and it now works.  Weird.  There must have been something that I had done in the initial setup.  Thanks for the response though.  Cheers!