How to convert date string from JSON to date format

What dates are those in a friendly format?

Take a look at the “Convert a value” workflow action: Convert a value

They are from Excel and look like this (see table below).

I’m using the “Read Excel File” connector from the Nintex Connector Gallery. https://gallery.nintex.com/t/read-excel-file

It pulls the data in as a JSON string.  I run Nintex actions to grab these dates.  They come into Nintex as their date integers if you will in string format.

I convert the string to an integer and all is well.

As soon  as I run a convert to go from integer to date I get the following error: The specified value is unknown. [Error Code: TypeCasting.UnknownCasting]

Hi @davehtx 

You can use the Add Time to Date action to convert those number into actual Date.
Add the number to the date “01-Jan-1900”.  

You posted the following
→ Query JSON All Award Date - ["44907","","44562","45219"]. Using 44907

Add 44907 days to the date “01-Jan-1900”. Excel uses the value mean 44907 days after “01-Jan-1900”.

Configure the Add Time to Date action as below

Below is the Log to History result. 14-Dec-2022

FYI, our system date follows UK style - dd-mm-yyyy

Hope that helps.

Piggybacking off what @Garrett said, you should be able to use the “Add time to date” action in Nintex Automation Cloud to get the same result.