topic Re: Date String to Date in App Development

Date String to Date

evansabres — Wed, 28 Aug 2019 13:26:20 GMT

I have a date field called 'created_at' that comes into my application in the following format:

Mon Aug 26 14:04:21 +000 2019

How can I transform this in the script to show as a date in the format MM/DD/YYYY (from example above 8/26/2019

Re: Date String to Date

dplr-rn — Wed, 28 Aug 2019 13:35:59 GMT

try something like below
=Date(Date#(SubField('Mon Aug 26 14:04:21 +000 2019',' ',2)&'-'&SubField('Mon Aug 26 14:04:21 +000 2019',' ',3)
&'-'&SubField('Mon Aug 26 14:04:21 +000 2019',' ',6),'MMM-DD-YYYY')
,'MM/DD/YYYY')

Re: Date String to Date

evansabres — Wed, 28 Aug 2019 13:40:54 GMT

Where do I place my current field of 'created_at'

Re: Date String to Date

dplr-rn — Wed, 28 Aug 2019 13:45:54 GMT

instead of 'Mon Aug 26 14:04:21 +000 2019' place created_at

=Date(Date#(SubField(created_at,' ',2)&'-'&SubField(created_at,' ',3)
&'-'&SubField(created_at,' ',6),'MMM-DD-YYYY')
,'MM/DD/YYYY')

Re: Date String to Date

Vegar — Wed, 28 Aug 2019 13:47:41 GMT

Replace 'Mon Aug 26 14:04:21 +000 2019' in @dplr-rn solution above with [created_at] like this

Date(Date#(SubField([created_at], ' ',2)&'-'&SubField([created_at] ,' ',3)
&'-'&SubField( [created_at], ' ',6),'MMM-DD-YYYY')
,'MM/DD/YYYY') as [Created at]

Re: Date String to Date

evansabres — Wed, 28 Aug 2019 16:02:27 GMT

Thank you for your input. A follow-up question, would be if I wanted to get the Day of Week and Month from that field and create new fields called Day and Month, how would I do that in the script?

Re: Date String to Date

dplr-rn — Wed, 28 Aug 2019 16:05:51 GMT

You would use Day and Month function

Day(Datefield) as Day,

Month(Datefield) as Month,

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm