Linx Main Linx Help

Xero Convert DateTime to date


#1

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.


#2

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:

XeroDateTime.ToString(“yyyy-MM-dd”)

Let me know if this doesn’t help.

Dawie


#3

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…

2017-12-31_8-05-44