Discussion board where members can get started with QlikView.
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,
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')
you can use the LongMonthNames
Set LongMonthNames =
subfield(field, ' ', 1) & ' ' &
left(subfield(field, ' ', 2),2) & ' ' &
subfield(field, ' ', 3)
'MMMM DD YYYY')
,'DD/MM/YYYY') as newfield
January 11th 2018 12:00:00
January 01st 2018 12:00:00
February 02nd 2017 03:00:00
Roman Emperors and the Month Names