Formula: how to compare a Date Only column with a given Month?

(0) Share

Report

Posted on by AliceW

286

Hello guys,

I'm trying to get something like

If('Start Date' > Date(2025, 1, 1), 10, 0).

'Start Date' is a column in my table. The date, I'd like to hard-code.

Does anyone know how to do this in the Dataverse?

It's a Formula column.

Thank you!

Alice

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

What is the problem that is occurring?

Where is the month value which you are trying to compare?

Was this reply helpful? Yes No
AliceW 286 on at

Like (0)

Report

Well, the problem is the formula won't save with this text.

'Start Date' is a Date Only column in the table.

I want to compare it with 1-Jan-2025.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Date is not a valid function.

Why do you want to compare it to a fixed value in the table?

Was this reply helpful? Yes No
AliceW 286 on at

Like (0)

Report

Long story... I basically want to stop some columns from calculating if after, say, January.

Was this reply helpful? Yes No
Akah Mandela 445 on at

Like (0)

Report

can you try this instead:

If(
DateValue('Start Date') > Date(2025, 1, 1),
10,
0
)

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report
The following suggestion is clumsy and hacky and is dependent on whether you are using time zone independent dates. You can create the static date using the DateAdd function subtracting today's date and adding the date which you want.

DateAdd(DateAdd(DateAdd(UTCToday(), 2025 - Year( UTCToday()), TimeUnit.Years), 1 - Month( DateAdd(UTCToday(), 2025 - Year( UTCToday()), TimeUnit.Years)), TimeUnit.Months), 1 - Day( DateAdd(DateAdd(UTCToday(), 2025 - Year( UTCToday()), TimeUnit.Years), 1 - Month( DateAdd(UTCToday(), 2025 - Year( UTCToday()), TimeUnit.Years)), TimeUnit.Months)), TimeUnit.Days)

is a substitute for Date(2025,1,1)

Was this reply helpful? Yes No