Formatting date fields

Answered

Comments

3 comments

  • Avatar
    Monika Yadav

    Hi Mary,
    I have created the formatted report under the same Dashboard with formatted date. 
    The calculation I used is: 

    Steps to follow:
    1. To show the dates in a format we want, first we are using the function extract_year(), extract_month(), extract_days() to extract month, date and year from a date, in this case skill expiry date. For example, extract_days(${employee_skill.expiry_date_date})

    2. Once we have that ready, we are going to use concat() to add different pieces we extracted in the above steps in a way we want. So for this function I passed extracted pieces in a format of mm/dd/yyyy, separated by a comma.
    concat(extract_months(${employee_skill.expiry_date_date}),"/",extract_days(${employee_skill.expiry_date_date}),"/",extract_years(${employee_skill.expiry_date_date}))

    3. For the values that are null, we are checking if they are null, if yes then saying show null otherwise show the formatted date. 
    if(is_null(${employee_skill.expiry_date_date}),"Null","show me the formatted date by using extract() and concat())

    So in the calculation its in the sequence: checking null, concat and then extract.

    Hope this helps.! 
    Monika

    0
    Comment actions Permalink
  • Avatar
    Mary McMullen

    Monika, 

    Thank you! I just created a new report in our "Scheduling" Dashboard called COVID_Scheduled Visit Check Last 14 days for contact tracking. I think I successfully converted the date into mm/dd/yyyy format. Am I unable to move the calculation field between the client first name and cancel code fields? I tried to drag it over to rearrange, but it will not allow me. Am I doing something wrong? 

    0
    Comment actions Permalink
  • Avatar
    Monika Yadav

    Hello Mary,
    By order, Calculations(in green color) and measures (in orange color) cant be dragged and dropped to change the sequence of columns. Only the blue columns can be rearranged. 

     

    Thanks
    Monika

    0
    Comment actions Permalink

Please sign in to leave a comment.