Answered

date formula

Like (0) Share

Report

Posted on 26 Jul 2022 21:01:11 by Noone123

hello everyone, I need help what happens is that I have a list of sharpoint in which I have different animals with date of birth, I need that the formula me remove the animals according to the month in which this is, say if today is July the month is 07, all the 07 animals are eliminated when it is in July and so with the following months, but this formula that I am using does not work or if it is not the correct, I add the current month with 1 more and gives me the 08 August but at the time of eliminating the item does not eliminate anything, please if I have to use another formula or if I am failing at something

All responses (2)

Answers (1)

Verified answer

v-liwei-msft on 01 Aug 2022 at 08:23:41

Like (0)

Report

Re: date formula

Hi @Noone123,

Could you please tell me:
What is the datatype of your nacimiento column in SharePoint?
In your second screenshot, the two parameters of the formula you entered in the filter query are not equal.
2022-8 is not equal to 2022-08.
The value returned by the formatDateTime function in the third screenshot is of type 'yyyy-MM' (eg 2022-08).
2022-8 is not equal to 2022-08.
Make sure your nacimiento columns are formatted correctly.

Best Regards,
Levi
Caspar_Rubin 830 on 27 Jul 2022 at 18:12:39

Like (0)

Report

Re: date formula

Hey, your Filter Query in the "Get items" action is missing the spaces between the dash (-).

Shouldn't it be

nacimiento eq '2022 - 08'

instead of

nacimiento eq '2022-08'

? 😃