Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pushpita
Contributor

Date and Time Format

Hi,

i have a date format like : "Thu Jan 19 11:23:27 SGT 2017" . i want to make it like : 'DD/MM/YYYY hh:mm'.

1 Solution

Accepted Solutions
rahulpawarb
Valued Contributor II

Re: Date and Time Format

May be this:

=Date(Date#(Replace(Mid(Field,5),' SGT ',' '),'MMM DD hh:mm:ss YYYY'), 'DD/MM/YYYY hh:mm')

Reference: Time stamp Format with TimeZone

Regards!

Rahul Pawar

8 Replies
sharathr
New Contributor II

Re: Date and Time Format

Hi Priyabrata ,

You can use data strings to separate or split in required format.

Share link for string functions , have a look for required format

string funtions

Regards,

Sharath R

rahulpawarb
Valued Contributor II

Re: Date and Time Format

May be this:

=Date(Date#(Replace(Mid(Field,5),' SGT ',' '),'MMM DD hh:mm:ss YYYY'), 'DD/MM/YYYY hh:mm')

Reference: Time stamp Format with TimeZone

Regards!

Rahul Pawar

Not applicable

Re: Date and Time Format

Working fine....helpful

Re: Date and Time Format

Hi,

You can go for MakeDate() function for this and spread your date string in Year, Month, Day and then convert the current date to your date format.

Regards

Anand

sureshqv
Esteemed Contributor III

Re: Date and Time Format

Hi Anand,

After long time nice to see you back in community ..Hope you will continue the same with different approaches

Best

Chanty.

Re: Date and Time Format

Thanks sure, i am always here to help you all.

Regards,

Anand

sureshqv
Esteemed Contributor III

Re: Date and Time Format

Nice to Hear Anand thanks too.

sasiparupudi1
Honored Contributor III

Re: Date and Time Format

Please close this thread by selecting a correct answer