Get specific date format 22.07.2025 -> 2026007

[SplittFPS]

I want to use a button to filter a specific date.

For example: the current date would be 22.07.2025 and want the output to be 2026007 and 22.12.2023 would be 2024012

I did one where I only needed the year which I did with  =Year(now())+1 and this worked 

Any ideas?

[brunobertels]

Hi 

may be this 

year(date(date#('22.07.2025','DD.MM.YYYY')))+1&

num(month(date(date#('22.07.2025','DD.MM.YYYY'))),'000')

[Or]

Year(YourDate) * 1000 + Month(YourDate)

[SplittFPS]

Hi thanks, this works for a specific date but is there a way so it takes the current date every time like in the formula for the year which I used?

[adilio_silva · Accepted solution]

Try this:

=Year(Today())*1000 + Month(Today())

 

[SplittFPS]

This worked, Thank you