Forum Discussion

PriscaSalve's avatar
PriscaSalve
Frequent Visitor
3 years ago
Solved

year function

  when I apply the data type in text it show current size and when i apply data type in year its show this result kindly help 
  • SamInogic's avatar
    SamInogic
    3 years ago

    Hi PriscaSalve,

    Can you just make sure if you have created a Relationship between Year column of "STARTUP FILE" table and Year column of "Table 2"? 

    Please refer to the below screenshot for sample reference,


    Thanks!

    Inogic Professional Service Division

    An expert technical extension for your techno-functional business needs

    Power Platform/Dynamics 365 CRM

    Drop an email at [email protected]

    Service:  http://www.inogic.com/services/ 

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi PriscaSalve 

the result of YEAR() is by default set as Whole Number. Do not change the type to Text, it seems OK, but you might need to calculate on year or at least compare them. If you change the type to Date, it takes the year number as a serial number starting from 1899-12-31, which is wrong.