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
Community Support
7 years ago

Hi  Anonymous ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy