Ricerche recenti

Nessuna ricerca recente

Casting a custom attribute as a date

Con risposta
image avatar

Chris Gould

Data ultimo post: 28 set 2021

Hi everyone,

I'm hoping this is a obvious/simple solution.

I am trying to do some rough forecasting which looks at a date 90 days after the ticket is solved. I'd like the attribute to behave like a date attribute where I can apply ranges or ideally even split into weeks and months, however, I know the latter requires extra work.

Here is my code so far and I'm stumped as to why it's not appearing as a date.

DATE(DATE_FORMAT(DATE_ADD([Ticket solved - Date], "day", 90), "yyyy-MM-dd"))

1

3

3 commenti

Data
    image avatar

    Erin O'Callaghan

    Zendesk Documentation Team

    Hi @..., the code you wrote above is working as expected for me in my test instance (for example, I see 2021-09-14). One quick thing to double-check is that you've created this as a standard calculated attribute—if you've accidentally created it as a standard calculated metric, it'll return as blank. :) 

    0

    image avatar

    Chris Gould

    Hi @...S O'Callaghan,Yes the formula definitely works, however, I need to function as a date. Not just a normal attribute field.

    So I would like to apply ranges to it like you might with ticket created-date and ticket solved - date.

    For example: show me the "New attribute" for This month

    0

    image avatar

    Maryann Remy

    My understanding is that it's not possible to apply custom ranges to custom attributes based on all my research. I am still looking for a workaround so I don't have to manually update the filters if I am interested in looking at my custom date attribute for just last week as an example. 

    0

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post