topic Re: Dates duplicated. in App Development

Dates duplicated.

brunod — Wed, 18 Sep 2024 22:08:17 GMT

I do have a date, in the the format like 2011-11-19 00:00:00, used this function to narrow down to year-month:

Date(Floor(Date#(Trim(dat_calculo), 'YYYY-MM-DD hh:mm:ss')), 'YYYY-MM') as [CC Ano-Mês CalculoTRIM]

But the problem that it gives duplicates for the year months, for example 3 entries 2024-06, 5 entries like 2024-01, but they represent the same date space.

How to solve this to give unique Year-Month selections?

Re: Dates duplicated.

Lisa_P — Thu, 19 Sep 2024 00:00:46 GMT

stead of Floor, use the monthstart function

Re: Dates duplicated.

ali_hijazi — Mon, 23 Sep 2024 05:40:29 GMT

that's because your date values contain time
use the below to remove or rest the time:
monthname(daystart(your_date_field)) as your_date_field