Date format as dd/mm/yy and remove the time stamp

[biswajitoram]

Hi Team, 

I am trying to get the column STARTDATE, ENDDATE, and DATECREATED as dd/mm/yy and but getting this error.

STARTDATE,ENDDATE,DATECREATED  = day month year, and cut time.  Sample 30 Apr 2022.

Expectation : 23/03/2023

Please help me on this issue.

[sk]

What date you are trying to get for start date, Is current date or system date?

[biswajitoram]

Hi SK,

STARTDATE is the system date when the user was created. We just want to remove the time stamp when the report will generate. 

[sk]

Try this

DATE_FORMAT(u.startdate, "%d %b %Y")

[biswajitoram]

I have tried ad getting the expected date format in Data Analyzer, but when I tried in Analytics it's giving me an ERROR.

I'm not sure why it's showing like this. Please help me with this.

[sk · Accepted solution]

V2 Analytics doesn't allow column name alias ending with date change respective columns differently like 

for Start Date use Date_Started

for end date use Date_ended something like that and it should work

[biswajitoram]

Thanks for your quick support Mr.SK