topic Re: how to change date format and show output in Visualization and Usability

How to Change Dates With Different Format Into DD-MMM-YYYY and Sum their Values

sutharsan — Thu, 30 Jun 2022 08:48:21 GMT

QuestionOutput

Re: how to change date format and show output

sidhiq91 — Thu, 30 Jun 2022 05:31:03 GMT

@sutharsan Which Date Column are we talking about here? Because I see date column from multiple table.

However your can try Date('Date','DD-MMM-YYYY')

Else

Date(Date#('Date','DD-MMM-YYYY'),'DD-MMM-YYYY')

Re: how to change date format and show output

sutharsan — Thu, 30 Jun 2022 05:35:49 GMT

Hi man,

we need to change all the date format to DD-MMM-YYYY and display it as one table and sum the values .

Re: how to change date format and show output

sutharsan — Thu, 30 Jun 2022 05:36:46 GMT

Tried these but it showing null values

Re: how to change date format and show output

sidhiq91 — Thu, 30 Jun 2022 05:38:05 GMT

@ Can you please provide the sample data set?

Re: how to change date format and show output

sutharsan — Thu, 30 Jun 2022 05:41:56 GMT

Here You Go

Re: how to change date format and show output

sutharsan — Thu, 30 Jun 2022 08:34:38 GMT

T1:
Load
Date(Replace(Date,'o','0'),'DD-MMM-YYYY') as DATE,
Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Concatenate
LOAD
Date2 as DATE,
Value2 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Concatenate
LOAD
Date(Date3,'DD-MMM-YYYY') as DATE,
Value3 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Concatenate
LOAD
Date(Date#(Date1,'DD-MM-YYYY hh:mm:ss TT' ),'DD-MMM-YYYY') as DATE,
Value1 as Value
FROM [lib://DB/Date Task.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

T2:
Load
DATE,
Sum(Value) as VALUE
Resident T1
Group By DATE;
Drop Table T1;

Got the Answers hope it might be usefull

Re: how to change date format and show output

charishma01 — Thu, 30 Jun 2022 08:41:03 GMT

Date(Date, 'Date format') as newdate;