Arabic (Hajri) Dates converter

[SkorpionAAM]

I have data where dates are in Arabic (Hajri) (12/06/1443) dates i want to convert hajri dates to Georgia format as im doing calculation with today funcation which is calculting from geirgia dates is there any way where i can use hjri today date or converter where i convert hijri to Georgia 

thanks 

 

[aj1973 · Accepted solution]

Hi @SkorpionAAM 

Go to Power Query, select the date column/Type, then select Type Locale and change the column type to 

[Fowmy · Accepted solution]

@SkorpionAAM 

In Power Query, right-click the column with Hijri Dates, Choose Change Type, Use locale, Select as follows:

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[abdullahkash99]

= Table.TransformColumnTypes(#"Changed Type with Locale1",{{"date today", type text , "yyyy mm dd"}})

how change format the date ? 

[aj1973 · Accepted solution]

Hi @SkorpionAAM 

Go to Power Query, select the date column/Type, then select Type Locale and change the column type to