Date format

[SatyaPaleti]

Hi Friends,

I am having a field called Date it is in

10/29/2015 12:45:22 AM format

I Want to show in 29-Oct-2015 format.

What is the exact function I need to use here

Thank you,

Satya Paleti

[handry_orozco]

Hi Friend

Try,

Table_tmp:

LOAD

     Day(date) AS Day,

     Month(MonthName(date)) AS Month,

     Year(date) AS Year

FROM Table1.Qvd;

NoConcatenate

Table:

LOAD Day&'-'&Month&'-'&Year AS Date

Resident Table_tmp;
Drop Table Table_tmp;

bye

[#3]

Hi

use

=Date(DateFiled,'DD_MMM-YYYY')

[settu_periasamy]

Try like

Date (Date#(YourDateField,'MM/DD/YYYY HH:MM:SS TT'),'DD-MMM-YYYY') as Date

[SatyaPaleti]

Hi Settu,

Thank you for your reply but it's not working here

Thank you,]

Satya Paleti

[HirisH_V7]

Hi,

Date:

Load*,

TimeStamp(

  Alt(

      TimeStamp#(Date,'MM/DD/YYYY hh:mm:ss')

),'MM/DD/YYYY'

  ) as New_Date_Value

;

LOAD * INLINE [

Date

10/29/2015 12:45:22

10/30/2015 12:45:22

];

Please check this .May be helpful

Thanks,

hirish

[Chanty4u]

hi satya,

Please chk below links

https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

https://community.qlik.com/message/847632#847632

hope this helps u

Regards,

Suresh

[Chanty4u]

hi,

=Timestamp(Timestamp#('9/13/2015 2:40:49 AM', 'MM/DD/YYYY hh:mm:ss TT'), 'DD-MMM-YYYY') as date

hope this helps u

Thanks

Suresh

[ElizaF]

Hi,

Possibly because you did not set the data format at the beginning of the script.

Please, set variable:

SET DateFormat='MM/DD/YYYY hh:mm:ss[.fff] TT';

and after try the function provided by settu_periasamy.

[MK_QSL]

At Front End

=Date(Floor(TimeStamp#('10/29/2015 12:45:22 AM','MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YYYY')

or

=Date(Floor(TimeStamp#(YourTimeStampField,'MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YYYY')

At Back End (in script)

Date(Floor(TimeStamp#(YourTimeStampField,'MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YYYY') as DateField