Is there a formula to check a date is after a specific date?

Hi, I'm currently trying to create a formula to look at a persons start date in the company and check whether that date is after 1 June. However, I want to be able to run this every year so need to create a dynamic date for the year part of the formula but static part of the date for the 1 June part. Is there an easy way to do this? Thanks!

Accepted answers

JosephSerpis

Hi @donnell I mocked up an approach to do this which use the function DateTimeToday() and extracts only the year part and keeps the rest of the date as June 1st. Let me know what you think?

Dates_10032021.yxmd

Emil_Kos

Hi @donnell,

I have created a workflow for you:

Output:

1 jun.yxmd

Emil_Kos

Hi @donnell,

1 Jun shows the nearest previous June date.

Hope this is helpful:

1 junv2.yxmd

All comments

JosephSerpis

Hi @donnell I mocked up an approach to do this which use the function DateTimeToday() and extracts only the year part and keeps the rest of the date as June 1st. Let me know what you think?

Dates_10032021.yxmd

Emil_Kos

Hi @donnell,

I have created a workflow for you:

Output:

1 jun.yxmd

donnell

Worked brilliantly - thank you both!

donnell

Any ideas on how you would amend the formula say if the date was 1 February and we wanted to look back to the previous June? The Datetime today won't work for me as it is not the current year

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703