So I thought I had the answer to this question I had posted before, but it is not exactly working as expected.
If(
IsBlank(
Text(DateValue(First(Sort(Filter(colEquip, 'Equipment Type' = "Safety Toe Boots" & User().Email=CurrentUserEmail ), 'Purchase Date', Descending
)).'Purchase Date' ))),
"Today",
Text(DateAdd(DateValue(First(Sort(Filter(colEquip, 'Equipment Type' = "Safety Toe Boots"), 'Purchase Date', Descending
)).'Purchase Date' ), 2, Years ),
"mm-dd-yyyy"))
I have a field in my screen that displays the dollar amount paid and what I am looking to have this do is if, Purchase Date is empty then display Today, otherwise display the Purchase Date plus two years. It is not working
Dorinda, add a text box into there and set its value to
IsBlank(
Text(DateValue(First(Sort(Filter(colEquip, 'Equipment Type' = "Safety Toe Boots" & User().Email=CurrentUserEmail ), 'Purchase Date', Descending
)).'Purchase Date' )))
and see if it is returning the value you would expect, and we can go from there. Always easier to troubleshoot these if you separate the working parts and get them all functioning independently of each other first if you are having issues I find
Came back as True
Ok so, in that purchase date box, I see a date is there which obvs mean this formula isn't returning wjhat you expected. Do you mind sending the Value put into that textbox/label that is showing a date correctly, and gallery items property as well, if this is a gallery
Actually think I see the issue.
IsBlank(
Text(DateValue(First(Sort(Filter(colEquip, 'Equipment Type' = "Safety Toe Boots" & User().Email=CurrentUserEmail ), 'Purchase Date', Descending
)).'Purchase Date' )))
should be
IsBlank(
Text(DateValue(First(Sort(Filter(colEquip, 'Equipment Type' = "Safety Toe Boots" && User().Email=CurrentUserEmail ), 'Purchase Date', Descending
)).'Purchase Date' )))
needs an extra &, to be &&
User | Count |
---|---|
260 | |
127 | |
101 | |
49 | |
47 |