Date displays null

[mehrwadh]

Hi,

We have a workflow that reads data from SharePoint list. For uncertain reason, all the columns that has dates are reading as null in my workflow. However, when the same query is run by my colleague they work perfectly. 

Need help from the experts and appreciate your response.

Attached the source and the output screenshot for reference. 

Best Regards,

Harsha

[binuacs]

@mehrwadh Check your Data Type of the field Date Requested in the workflow. If it is a string type then you need to apply the DateTimeParse() function

[mehrwadh]

Thank you @binuacs

The data type is already set to Date and Time. 

The same workflow works fine on my colleague system. We reviewed each fields line by line, but date appears null in my system. Infact when we connect input to source and refresh, the source itself reads as null whereas dates are present at source.

[DataNath]

@mehrwadh if you try to bring it in as a string, does that help? At the moment, it looks like your Sharepoint input is in DD-MM-YYYY HH.MM format, whereas Alteryx can only deal with DateTime fields in ISO format (YYYY-MM-DD HH:MM:SS). Therefore, you'll have to bring the field in as is, as a string. If you need this as a DateTime() data type for downstream processing, you can do the conversion by using the DateTime tool or DateTimeParse() function within a formula tool.

Additional info here: https://help.alteryx.com/20221/designer/datetime-functions

[mehrwadh · Accepted solution]

Hi DataNath,

Thank you for your response. Yes, we tried to pull the dates in string format, still those fields appears null. 

You note on how our Sharepoint input is (DD-MM-YYYY HH.MM) was really helpful. I set my machine display date and time in the same format as SharePoint and this really resolved the problem.

Trust me we tried various options and spent too much time to find solution on Alteryx Community and other platforms. But failed to know the cause. A small trick on setting date and time in line to SharePoint really worked.

Best Regards,

Harsha