Datefield not recognized as Date

[beck_bakytbek]

Hi Folks,

i am facing this issue: 

my Field does look like:  Martin Smith / 01.02.16

i divided this filed by using of Function: Subfield () into 2 Fields: Employee = Martin Smith and Datafield= 01.02.2016.

But if i try on the base of Field: Datafield to make the Year() and Month (), i recieve the empty fields. The Datafiled will not recognized as Datafield.

Does anybody have any Suggestion or idea how to resolve this issue?

Thanks a lot

Beck

[pradosh_thakur]

DATE(date#(Datafield,'DD.MM.YY'))

[sunny_talwar · Accepted solution]

Try this

Date#(Trim(SubField(FieldName, '/', 2)), 'DD.MM.YY') as DateField,
Month(Date#(Trim(SubField(FieldName, '/', 2)), 'DD.MM.YY')) as Month,
Year(Date#(Trim(SubField(FieldName, '/', 2)), 'DD.MM.YY')) as Year,

[beck_bakytbek]

Sunny thanks a lot for your help and time