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

[sutharsan]

QuestionOutput

[sidhiq91]

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

[sutharsan]

Hi man,

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

[sutharsan]

Tried these but it showing null values

[sidhiq91]

@ Can you please provide the sample data set?

[sutharsan]

Here You Go

[sutharsan · Accepted solution]

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

[charishma01]

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