Forum Discussion
Date/Time Parameter drops Time portion of the string
Out of interest, are you still having an issue with this parameter?
Here are a few things I would check if I were debugging this.
1. Does the parameter behave as a valid datetime value when referenced by other queries?
2. Could you post a screenshot of the Manage Parameter dialog box and the M code from Advanced Editor? I would expect something like below (with possible differences due to regional settings):
#datetime(2024, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]3. If you create another query by referencing the parameter directly, does it show the expected datetime value, similar to this?
4. If you create another query to inspect the parameter's type, e.g. = Value.Type(Parameter), does it show datetime, similar to this?
I've attached my PBIX in case that helps in any way.
Community SupportHi kg_iconic,
Thank you for reaching out to Microsoft Fabric Community.
Thank you govind_021 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Community SupportHi @kg_iconic,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided or by the super user resolved your issue?
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
- v-achippa
Hi @kg_iconic,
We wanted to kindly follow up to check if the solution I have provided or by the super user resolved your issue?
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa