How to convert 0032018 into dd/mm/yyyy

[daya]

Hi All,

I have data '0032018' in date field and I want it to convert into dd/mm/yyyy like '01/03/2018'

plz help.

thank you.

[dplr-rn]

What does other date values look like.
Do You always want it as start of the month?

[daya]

Yes I want it as start of the month and other date values are also in same format.

[dplr-rn · Accepted solution]

always 0 as day?
if so try this approach
=Date(MonthStart(Date#('1'&'0032018','DDMMYYYY')),'DD/MM/YYYY')
return 01/03/2018

in your scrpt
Date(MonthStart(Date#('1'&DATEFIELD'DDMMYYYY')),'DD/MM/YYYY') as NewDateField

[dplr-rn]

basically force a dummy day value (always day 10 in this case) and then use monthstart to move to start of month and then format it

[Sue_Macaluso]

@daya Is this for QlikView or Sense? I would like to move this into the correct product forum. 

[jayaramp]

Hi,

Believe following is the expression you are looking for.

Date(Date#(DateFieldName,'DDMMYYYY'),'DD/MM/YYYY')

Thanks!

[daya]

This is for Qlik Sense.

[daya]

@dplr-rn thanks..it works