I have the column Birthday (BirthDate), on table Contact, having Format - DateOnly. I want to create a calculated column BirthDateTime, on table Contact, having Format - DateTime and populate it from BirthDate. How can I do that? Or the way around?
The reason I am asking is that I want to use DIFFINYEARS for calculating age and it is not possible to compare BirthDate with NOW(), ie. DIFFINYEARS(BirthDate,NOW()) due to difference in Format. Otherwise it seemed to be a simple solution.