Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try this
Date(Date#(Date,IF(Len(Date) = 8, 'DD/MM/YY','DD/MM/YYYY'),'DD/MM/YYYY')
Kind regards