You’re offline. This is a read only version of the page.
438
@dylandavis09 I created this example. This shows the user birthday and then a trimmed version of it. The same for Today's date. Then I have an icon and a message that appear if the dates match and the user chose "Yes" on whether to show the message. For my example, I used a collection as my datasource, but you can easily adjust it for your datasource and columns.
To trim the birthday:
Share
Report
All responses (
Answers (
Text(DateValue(userBirthday.Text),"mm/dd")To trim today's date:
Text(Today(),"mm/dd")The code in the visible property of the birthday message:
If(userBdayTrimmed.Text = todaysDateTrimmed.Text && showBirthday.Text = "Yes",true,false)
I found it and fixed; correct is Filter('DHS All Users', Birthday = Today())
Yeah! Birthday is a datefield. Still error, why! I using "default" is a property, and items put it in 'DHS All User'.
maybe the issue was that i forgot that one is a datefield in sharepoint.
can u try this please:
Text(Today(), "MM-dd") = Text(ThisItem.Birthday, "MM-dd")
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
Still error.. Error message: "Incorrect format specifier for 'Text'."
try this instead
DateDiff(
DateValue(Text(Today(), "MM-dd-yyyy")),
DateValue(Text(ThisItem.Birthday, "MM-dd") & "-" & Text(Today(), "yyyy")),
TimeUnit.Days
) = 0
what do you mean with the yes part?
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
Error Message: Incorrect format specifier for 'Text'. Remember, I need to add "Yes" if they wants to visible.
Correct, in the gallery.
do you show the birthday also in the gallery or outside in a text label?
for the visible property you could do something like this:
Text(Today(), "MM-dd") = Text([YourDataSource].Birthday, "MM-dd")
In this formula, replace [YourDataSource] with your actual data source name and adjust any field names as necessary.
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
