Date format help

[mahitham]

Hi Experts,

Can any one please help me to convert the below date formats.

I have extracted Date1 and Date2 fields from SharePoint and stored in to qvd.

When I have taken those dates into table I am getting below format.

Here I have to show 13/06/2017     for  2017-06-12T23:00:00Z  and

                                 15/06/2017     for   2017-06-14T23:00:00Z  etc...

Please help me on this.

Thanks in advance.

[YoussefBelloum]

Hi,

try this:

Date(TimeStamp#(Date),'DD/MM/YYYY') as Date

[mahitham]

Hi Youssef,

Thanks for your reply.

By applying the above syntax for Date1 I am getting 12/06/2017 but that format is equal to 13/06/2017.

2017-06-12T23:00:00Z here T23:00:00Z  need to consider.

Please help me on this.

[jyothish8807]

Hi Mahitha,

Try this:

ConvertToLocalTime(timestamp#(replace(F1,'T',' '),'YYYY-MM-DD hh:mm:ssZ'),'Kolkata') as Date;

Note: F1 will be your date field

Br,

KC

[jyothish8807 · Accepted solution]

Add a date parameter out side:

date(ConvertToLocalTime(timestamp#(replace(F1,'T',' '),'YYYY-MM-DD hh:mm:ssZ'),'Kolkata'),'DD/MM/YYYY') as Date;

[mahitham]

Thanks a lot Jyothish

[neelamsaroha157]

If date formatting is not working for you then may be you can use makedate(left(Date,4), mid(Date,6,2), mid(Date,9,2)).

[jyothish8807]

You are welcome