Text field with typed in date

[D19PAL]

Hi,

I've got two fields 

ID, textfield

1, fghh

1, 56gh

2,  01-12-1987

3, hghug654

2, 07-12-1987

I want to create an if statement, if ID = 2, show me the two dates in new field as dates not text.

Thanks

[stevejoyce]

if(ID =2, date#(textfield, 'DD-MM-YYYY') as new_date_field

[OmarBenSalem · Accepted solution]

Maybe somthing like
if(ID=2, date(date#(textfield,'DD-MM-YYYY')),textfield) as YourField

[D19PAL]

That's giving a result of 0, which is not what I was expecting 

[D19PAL · Accepted solution]

Trying it now, thanks

[D19PAL]

Worked a treat thanks