topic Re: output is match according to date but according to month is not match in Visualization and Usability

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

AnkitaC — Thu, 08 Sep 2022 11:02:32 GMT

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

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

brunobertels — Thu, 08 Sep 2022 13:57:15 GMT

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'))

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

AnkitaC — Thu, 08 Sep 2022 14:02:00 GMT

ok i will try and update thank you

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

AnkitaC — Thu, 08 Sep 2022 14:09:55 GMT

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