Date Format issue

[kakani87]

Hi Folks,

Issue in loading Date field.

I'm pulling a date field from my data base where it returns a number for that used following in script all are displayed in number format.

//date(Dt,'YYYY-MM-DD') as tran_date,

//Dt as tran_date,

//date(Dt) as tran_date,

//Date(Date#(Dt),'DD/MM/YYYY') as tran_date,

floor(date(Dt)) as tran_date,

when I'm considering floor() then as well it is returning number only but now in front end while using date dimension applied date(tran_date) and able to display the correct date value only when used floor () it can be done in my scenario.

Now the issue is with while filtering the date it is displaying number format as '43101' , as per the requirement a current selection  box to be used and while filtering the date it is displaying the number but not the date format.

[Anil_Babu_Samineni · Accepted solution]

May be this?

Date(floor(Dt)) as tran_date,

OR

Date(floor(Date(Dt))) as tran_date,

[kakani87]

My intention is to let you people know that only when i use floor () then i can format that number to date in front end 

[kakani87]

Thank you this is working Anil ...