output is match according to date but according to month is not match

[AnkitaC]

Hi Everyone,

please give me solution actually  'DD/MM/YYYY 00:00:00' this type of date field created_at is present in my database table. if i convert into the date using floor or date field function according to particular date data is match but monthly data is not match because time and date field both are in one field what to do in that situation please give me solution.

Thanks You................

Regards,

Ankita

[brunobertels · Accepted solution]

Hi 

you may not encouter issue with month() function even if your date field is a timestamp 

netherthe less try this 

date(floor(Timestamp('08/09/2022 15:47:36','DD/MM/YYYY hh:mm:ss')),'DD/MM/YYYY')

replace '08/09/2022 15:47:36', by your date field 

then month(date(floor(Timestamp('08/09/2022 15:47:36','DD/MM/YYYY hh:mm:ss')),'DD/MM/YYYY'))

another approach could be 

date(left(Yourdatefield,10),'DD/MM/YYYY') then 

month( date(left(Yourdatefield,10),'DD/MM/YYYY'))

[AnkitaC]

ok i will try and update thank you

[AnkitaC]

not change same output my query output is below attached but my dashboard is 310106 is not match if i select date particular date then its match but month wise not match