Linx Main Linx Help

Xero Convert DateTime to date

I had an issue with the dates from Xero DateTime to just Date, I tried adding .Date to the fields, but that didn’t work. How is it done? I need to drop the time portion off for BI.

Hi Mike,

In what format do you need the Date? From your previous post I assume your doing the JSON file, in which case I would do the following for the DateTime value in the Expression Editor:


Let me know if this doesn’t help.


I got this error on the Date and DueDate fields within the Invoice type , ‘No overload for method ‘ToString’ takes 1 arguments’ when I used .ToString(“yyyy-MM-dd”). Worked around it by creating two datetime fields, SetValue and ToString from those to output. See pic…