I created Two Calculated Fields :

  • The First Formula of Calculated Field =TEXT([Created];"mmmm") the Result is : First spring (Name Of Hejri Month in Hijri Format Arabic )
  • The First Formula of Calculated Field =TEXT([Created];"yyyy") the Result is : 2014 (year in Gregorian Format ) and when i make this Formula =TEXT([Created];"mmm") the Result is : Ramadan !!!??? It made me feel insane

Why is this ? it supposed to return 1435 Also When I open the item in DispForm.aspx its Appear as : created at 07/01/2014 11:00 AM , But When I Add Created Field To Default View of list , it's Appear as 06/03/35

Something else , in the Workflow it returns the value in Hijri Format , and I want to send email containing Date Field with Gregorian Format !!!

Thanks in Advance

  • Why should it return 1435? You didn't create the item in the year 1435.
    – Erin L
    Aug 11, 2016 at 16:01
  • i created it in 6/3/1435 Aug 11, 2016 at 16:03
  • None of us were alive in the year 1435... I should specify that's by the Gregorian Calendar.
    – Erin L
    Aug 11, 2016 at 16:08
  • SP dates are actually counters and start counting at january 1st 1900 .. I am not sure.. but I don't think SP handles negative dates Aug 11, 2016 at 17:32
  • This is an item created in the past , even the items that i created it today , calculated field return like this value Aug 11, 2016 at 17:39

2 Answers 2


Your DispForm.aspx is displaying the Gregorian date the item was created. The default view is using your regional dates. The date calculated fields return Gregorian dates, so "yyyy" returns 2014 because that's the Gregorian year of the Created date. I don't think calculated field dates can be manipulated in other regions' calendars.

For your workflow, use a calculated field to return the Gregorian date =TEXT([Created];"MM/dd/yyyy") and return that field in your workflow.

enter image description here

  • =TEXT([Created];"mmmm") return "ربيع الأول" ) First spring In Arabic !!!??? Aug 11, 2016 at 16:22
  • Don't use "mmmmm." Use MM/dd/yyyy
    – Erin L
    Aug 11, 2016 at 16:23
  • The comma in my answer should be a semi-colon for your region. I'll edit my answer.
    – Erin L
    Aug 11, 2016 at 16:24
  • i want to return only year of created date as 1437 , because i have field with name Hejri year Aug 11, 2016 at 16:30
  • i have four field ( year , month in Gregorian ) , ( year , month in Hejri ) , and its calculated and i get all result except year in hejri Aug 11, 2016 at 16:35

I solve it using This Formula :

  • For Hejri Month Field =TEXT([Created];"mmmm")
  • For Gregorian year Field =TEXT([Created];"yyyy")
  • For Gregorian Month Field =TEXT([Created];"mm")
  • For Hejri Year i used WorkFlow To Extract The First two litter From short Date String of Created Field

and For sending email containing Date Field with Gregorian Format , i created Calculated Field With this Formula =TEXT([Created];"dd/mm/yyyy hh:mm:ss AM/PM") and adding this Field to email body .

  • You should at least upvote my answer, since I'm the one who suggested you use Created Short Date
    – Erin L
    Aug 15, 2016 at 13:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.