Hello,
I have a weird problem here. In my perspective view, I am able to pull the data to my table before 12.59 pm but not for 1 pm and after that. I have no idea what is the problem here. Have you encountered such a thing before?
My dataset has a column titled “datetime_created” and its datatype is Date
Now in my history table, I am filtering based on a start time and end time.
I do not use any format transformation for dates and I am getting this preview:
However, I get this error too when I select the desired date/time:
Conversion failed when converting date and/or time from character string.
I tried pattern transformation, it is working but it is not showing the data after I choose 1 PM and above as an end date.
Check that your date formats are the same, ive seen some weirdness when they didn’t match.
1 Like
My dataset has a column titled “datetime_created” and its datatype is Date
Now in my history table, I am filtering based on a start time and end time.
I do not use any format transformation for dates and I am getting this preview:
However, I get this error too when I select the desired date/time:
Conversion failed when converting date and/or time from character string.
I tried pattern transformation, it is working but it is not showing the data after I choose 1 PM and above as an end date.
Found the issue!
The format pattern is wrong.
It should be:
yyyy-MM-dd HH:mm:ss
instead of
yyyy-MM-dd hh:mm:ss
1 Like
You could simplify things by utilizing the formatted value property of your date time input, that way you don’t need any custom properties or transforms.
1 Like
That’s a very good point! Thank you!!!