Expected Date time value in or condition

(0) Share

Report

Posted on by Ashok2

428

Hi All

I am trying below formula to set default date of column as per dropdown selection but getting error ion || "Expected Date time value " for other dropdwon selection value

If(DataCardValue29_1.Selected.Value="Test1" && Today()<=DateTimeValue(Text(Concatenate("01June",Text(Year(Now()))))),DateTimeValue(Text(Concatenate("30June",Text(Year(Now()))))),DateTimeValue(Text(Concatenate("30June",Text(Year(Now())+1))))) || If(DataCardValue29_1.Selected.Value="Test2" && Today()<=DateTimeValue(Text(Concatenate("01June",Text(Year(Now()))))),DateTimeValue(Text(Concatenate("30October",Text(Year(Now()))))),DateTimeValue(Text(Concatenate("3030October",Text(Year(Now())+1)))))

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashok2 ,

I am not entirely sure on your logic, but is this what you are trying to do?

With( { wYear:Text(Year(Now()), wNext:Text(Year(Now()+1), wSelected:DataCardValue29_1.Selected.Value, wDate:DateValue("01June" & Year(Now())>=Today(), }, Switch( wSelected, "Test1", If( wDate, DateValue("30June" & wYear), DateValue("30June" & wNext) ), "Test2" If( wDate, DateValue("30October" & wYear), DateValue("30October" & wNext) ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.