8
Views
3
Comments
Solved
Can't preview data with Date Time test value
Application Type
Traditional Web
Service Studio Version
11.10.0 (Build 34711)
Platform Version
11.8.2 (Build 15398)

Hi everyone,

     has anyone had this kind of issue before? I'm trying to test a query i made in an aggregate, I can confirm that both DateInit and the field I'm trying to filter by, are Date Time. If I remove the 12:00:00 it says that it's the '#' the unexpected element.

Any idea of what could be going on here? 

Rank: #95
Solution

Hello Oscar,

Hope you're doing well.

Can you please try like this?

Kind regards,

Rui Barradas

Rank: #128
Solution

Hi Oscar,

I think the error message is a bit confusing, the real problem is probably the first part : 

it should be #2020-12-11 12:00:00# for today 12 o clock, for example

Good luck,

Dorine

Rank: #95
Solution

Hello Oscar,

Hope you're doing well.

Can you please try like this?

Kind regards,

Rui Barradas

Rank: #30718

I feel kind of bad now, haha to be honest I didn't even pay attention to my date format. 

doing #YYYY-MM-dd hh:mm:ss# worked!

Thank you very much everyone!