topic Convert a string to a Date in QlikView

Convert a string to a Date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

Maybe someone could help me...

I have a string field called 'Departure' populate like that = [January 11th 2018 12:00:00]

I would like to convert it into a Date field/dimension => [01/11/2018]

Maybe someone nice could help me...

my brain is going to expose

Thanks a lot,

Thomas

ps: currently I get only the number of the month with the formula below:

=wildmatch((LEFT(Departure,FindOneOf(Departure,' '))), 'ja*','fe*','ma*','April','May','Jun','July','August','September','October','November','December')

Re: Convert a string to a Date

maxgro — Wed, 24 Jan 2018 20:42:06 GMT

you can use the LongMonthNames

Set LongMonthNames =

'January;February;March;April;May;June;July;August;September;October;November;December';

load

field,

date(

date#(

subfield(field, ' ', 1) & ' ' &

left(subfield(field, ' ', 2),2) & ' ' &

subfield(field, ' ', 3)

'MMMM DD YYYY')

,'DD/MM/YYYY') as newfield

inline [

field

January 11th 2018 12:00:00

January 01st 2018 12:00:00

February 02nd 2017 03:00:00

];

Roman Emperors and the Month Names