Irregular Date format

[ankit777]

Hi All

I have date format like shown below. How should I read this in QV.

Date:  

14/5/2016

04/05/16

29/4/2016

01/05/16

30/4/2016

31/5/2016

29/4/2016

27/4/2016

03/05/16

30/4/2016

[Anonymous]

Try this

Date(Date#(Date,IF(Len(Date) = 8, 'DD/MM/YY','DD/MM/YYYY'),'DD/MM/YYYY')

Kind regards