I am pretty new as well on this matter and I am learning by doing. Here are some tips I use to get my date and datetime data types working right in my dashboards:
Check the Data Type: Make sure the data type of your field in the data view matches the type you’re setting in your expression (date or datetime).
Watch the Date Format: Make sure the date format in your expression matches what’s expected by the data view. Different systems can have different date format requirements.
Use Date Functions: Try using date functions provided by App Studio, instead of setting a string value directly.
Hope these tips help you sort out your date and datetime data types.
Since you are using a BAQ, I recommend that when you’re in the BAQ designer, just add a new calculated field to handle this date conversion.
Here’s how to set it up:
Create a Calculation Expression: Just drop in the Date() function to strip off the time part from your DateTime field. You’ll write it like this:
`Date(YourDateTimeField)`
This will get you just the date, nice and clean.
Use Your New Calculated Field: Now that you’ve got this handy calculated field, you can use it anywhere in your BAQ outputs or for other calculations you need to do.