Solved: problem with date format,need help please! - Qlik Community

Report Inappropriate Content · ‎2014-08-13

hi,

I have a field coming from a csv file to my script having data in below format

1/14/2015 12:00:00 AM

I want to change this by removing the time stamp from it and make it to result date in

dd/mm/yyyy format.

how can this be done?? please can someone help

sahana

simenkg · ‎2014-08-13

try Date(Date#(subfield(Field,' ',1),'MM/DD/YYYY'),'DD/MM/YYYY')

avinashelite · ‎2014-08-13

Hi Sahana,

Use date(field,'DD/MM/YYYY') as fieldname in the script this will do the job,

amit_saini · ‎2014-08-13

Sahana,

Try this,

Date(Your_Date _Field, 'DD/MM/YYYY') as Date,

Thanks,

AS

Report Inappropriate Content · ‎2014-08-13

hi Avinash

I have tied it but it doesnt work.I have also tried

DATE(FLOOR(Timestamp#(field,'MM/DD/YYYY hh:mm:ss TT') ))

avinashelite · ‎2014-08-13

can you please post your app.

amit_saini · ‎2014-08-13

Please see the attachment.

Go to properties--> Number-->Select Date as decide format.

Thanks,
AS

amit_saini · ‎2014-08-13

Please see the screenshot:

Report Inappropriate Content · ‎2014-08-13

In script you can have a look,I have 2 columns.

Expiry,

date(Expiry,'DD/MM/YYYY') as Expiry1 ,

but Expiry1 doesnt work.

ashfaq_haseeb · ‎2014-08-13

Hi,

Can you attache your sample csv with few dated .

Regards

ASHFAQ

Report Inappropriate Content · ‎2014-08-13

hi Amit,

I want to do this conversion in the script level,where I would be using to join with other tables etc.Hence the issue.