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/

AilleryO's avatar
AilleryO
Memorable Member
3 years ago

Hi,

Or just simply create a column with format function :


Year = FORMAT( [YourDateColumn] , "yyyy" )

Hope it helps

 

PS : When you see your comumn as date type, it's normal you see 8 july 1905,
because it is 2014 days after the 1st january 1900.
Dates can be shown as serial numbers counting from 31/12/1899.