Forum Discussion
Resolver IStrange error with Date.DayOfWeek function
Hi v-lid-msft ,
good news: My colleague changed the type from datetime to datetime2 in the MSSQL view. After this both operations worked as expected!
Regards,
Thomas
Resolver IHi v-lid-msft,
yes, I managed to do a diagnosis. But to be honest, I cannot get a clue what went wrong from the diagnosis data. Do you want me to post it here?
An additional insight from testing: The same MSSQL table does not produce the error when accessing it directly, without a view. But my colleague who created the view checked it twice and could not find a cause for this.
Regards,
Thomas.
Resolver IHi v-lid-msft ,
good news: My colleague changed the type from datetime to datetime2 in the MSSQL view. After this both operations worked as expected!
Regards,
Thomas
v-lid-msftCommunity Support
Hi tez ,
Glad to hear you have solve your issue, sound like a great solution, thank you for sharing, we think it will help more users who have similar problems in forum.
Best regards,