Hello Qlik Members

[vamseekrishna]

Hi Everyone,

I am getting some problem to convert time format. I have time format it's in UTC mode, But i need to change into AEST(Australian Eastern Standard Time )..

Can please help how to convert UTC TO AEST(Australian Eastern Standard Time ) format..

Regards,

Vamsee

[neelamsaroha157]

May be this can solve your issue -

show data in correct time zone, can I do UTC+10 ?

[vamseekrishna]

Hi Neelam,

Thank you for your response......

I am tried as same functions but it's not working.. right now I am easy to convert present local time to AEST....

In my data I have large of data like 2017,2016... I am not able to change that format...

Regards,

Vamsee Krishna

[neelamsaroha157]

Would you mind sharing some sample data?

[vamseekrishna]

Hi neelam,

I have to 2 date format like

03/05/2018

4/05/2018

    ''

    ''

09/06/2018

this is one format

another one

like this

01/05/2018 4:51:07am

01/05/2018 4:51:13am

02/05/2018 8:02:57am

like

This is my date format in DB

Regards,

Vamsee

[jyothish8807]

Hi Namsee,

Try like this:

Load

Date,

ConvertToLocalTime( Alt(date#(Date,'DD/MM/YYYY'),timestamp(timestamp#(Date,'DD/MM/YYYY hh:mm:sstt'))),'Sydney') as New_Date;

LOAD * INLINE [

    Date

    3/5/2018

    4/5/2018

    9/6/2018

    01/05/2018 4:51:07am

    01/05/2018 4:51:13am

    02/05/2018 8:02:57am

];

Br,

KC

[vamseekrishna]

Thank you I will try on this

Regards,

Vamsee