Change date format to mmm dd yyyy

Questions & Answers
1

We want to change format from 2020-02-01 to Feb 01 2020
we have imported due date changes, whenever we are trying to update the formatting it doesn’t show up desired result

image
image1035×579 34.5 KB

2

eazyBI imports previous custom field date values as a comma separated string. While we can transfer one date (from string to date) using a desired formatting it is a bit challenging to apply this for cases when there is several previous dates.

Here is an example formula for this:

CASE WHEN
instr(
  [Measures].[Issue CF Due Date old values], ","
) > 0
THEN
Generate(
    Filter(
      -- get relevant dates from Time dimension
    [Time].CurrentHierarchy.Levels("Day").Members,
    AnyDateInPeriod(
      [Measures].[Issue CF Due Date old values],
      [Time].CurrentHierarchyMember
    )),
  -- apply the new formatting
  Format([Time].CurrentHierarchyMember.StartDate, 'MMM dd yyyy'),
  ",")
ELSE
  Format(DateParse([Measures].[Issue CF Due Date old values] ), 'MMM dd yyyy')
END

The formula above uses Time dimension day members to transform several dates in a new format. It applies simple formatting change for one date value.

Daina / support@eazybi.com

2 Likes
3

Hello Ramesh,

Can you help me how import duedate-oldvalue in eazybi?
I find below link page, but it works for jira cloud.

Thank’s
Azadeh