Date displays null

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

Source Output.png

Source.png

Date Time

Accepted answers

mehrwadh

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

All comments

binu_acs

@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

Date_1021.yxzp

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

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.

Best Regards,

Harsha

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335