Datetime parameter giving error "Enter a DateTime value"

Question

Hi Team, I m getting this error though im giving the right value. is there a way to fix this issue please. this is needed for implementing a Incremental refresh which needs these paramters in datetime type only.

danextian · Answer

Hi LP280388&nbsp;
&nbsp;
Please see the screenshot below:

Here's the M code
#datetime(2024, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]
&nbsp;

lp280388 · Answer

danextian,&nbsp;Hi Thanks for the response. For some reason its not working. I tried with multiple other formats too.&nbsp;&nbsp;#datetime(2024, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]&nbsp; when I give the above M code as well it shows as follows. I see mins 00 is missing though. would that be the reason why its not able fetch the datetime format?&nbsp;

danextian · Answer

#datetime(2024, 1, 1, 0, 0, 0)
YYYY, M, D, H, M, S - these time elements are required for the #datetime. You screenshot is missing the seconds. Also this M code looks fine to me

If you don't follow the required format, the M code will return a text instead of #datetime

I would suggest you copy the M code I gave and edit from there.

lp280388 · Answer

Yes I have been tring with the M code only. When I see in the output I see that the seconds are missing.&nbsp; Any idea what could be wrong with this datatime format?&nbsp;

anonymous · Answer

Hi&nbsp;LP280388&nbsp;This is quite a strange phenomenon. These operations work perfectly fine in my Power BI Desktop. If possible, you might want to try upgrading Power BI Desktop to the latest version to rule out whether this issue is caused by a version problem.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Jayleny
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.