Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Derive Year from Datetime field

Hi All I have a requirement to derive Year field from a datetime field (Field name is Installation DateTime). The data of the datetime field looks likes below :  The formula I used to derive  the y...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can change the data type of the Year column to Whole Number.

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You can change the data type of the Year column to Whole Number.

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.