Hi,
We have recently created and configured a new environment, but when you enter the Time & Expenses screen we get this error “System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string”.
Ive narrowed it down to when it calls GetRowsCalendarView with employee id and Payrolldate.
Every time anyone enters the screen it is defaulting 09/26/2021 as the Payroll date and this is the problem. I have tried calling it using Rest Swagger with the same dates and it still doesn’t work, but when I change this payrolldate to 09/12/2021 in Swagger it works. (UK formatted date).
So first question, where is it defaulting this date from? I thought it should use clockInDate (today?), but every user is getting this same date? When your then in the screen and try to add a new time entry the PayRollDate is actually displayed correctly as todays date.
Second question, is there a flag somewhere that we haven’t set as this is American date formatted but when I change the date in Swagger to a UK based format it all works so something is amiss.
Seems like a similar issue to this - All Time & Expense Entries are defaulting to one payroll date not sure if @tse.dba resolved it though.