I have used the function YearFromDate(DOB) but it doesn't like that I think because the field type is timestamp, so i thought first convert into into Date so I tried like : but no success again
Code: Select all
YearFromDate(TimetFromTimestamp(.BIRTH_DTTM))
But not working there is other function called
TimestampFromDateTime(%date%,%time%) but don't know how to pass argument I tried like that
Code: Select all
TimestampFromDateTime(DOB,DOB)