Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe somthing like
if(ID=2, date(date#(textfield,'DD-MM-YYYY')),textfield) as YourField
Trying it now, thanks
if(ID =2, date#(textfield, 'DD-MM-YYYY') as new_date_field
Maybe somthing like
if(ID=2, date(date#(textfield,'DD-MM-YYYY')),textfield) as YourField
That's giving a result of 0, which is not what I was expecting
Trying it now, thanks
Worked a treat thanks