How to get first date of the month from the selection

[Divyaverma2906]

How to get first date of the month from the selection

[Jonathan-Sherman · Accepted solution]

Hi @Divyaverma2906,

You could use the DateTimeTrim() function to solve this:

DateTimeTrim([Date],'firstofmonth')

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Christina_H]

Alternatively, if you're trying to find the earliest date in the month from the given list, try this:

[Divyaverma2906]

It worked. Thank you so much.

[Jonathan-Sherman]

No problem at all!