Text to date

[#1]

Hi,

My dataset has dates noted as follows:

03.06.2013

However, it are no dates; it is text, so I cannot do calculations with it. How do I change this to a real date, or a number (in this example to 41428), so I can do calculations with the dates?

Thanks.

[Nicole-Smith · Accepted solution]

If day is first then month:

date#(YourDateField, 'DD.MM.YYYY')

If month is first then day:

date#(YourDateField, 'MM.DD.YYYY')

[#3]

hi Dam

try this :

date(date#(03.06.2013,'DD.MM.YYYY'))