UiPath Community Forum

Maping

murali_potnuri (murali potnuri) March 31, 2023, 11:05am 1

Hello guys

Iam having a query that I am dates in web application and iam having dates on excel i should map those dates but in the Excel the date formate is (ddMMyyyy) but in application it was (MMddyyyy) formate is that possible to map please help me with this query

arjunshenoy (Arjun Shenoy) March 31, 2023, 11:11am 2

Hi @murali_potnuri

You can use the following query:

DateTime.ParseExact(stringDate.ToString,"ddMMyyyy", Globalization.CultureInfo.InvariantCulture).ToString("MMddyyyy")

stringDate is the variable in which you have your data from excel.

Hope this helps,
Best Regards.

murali_potnuri (murali potnuri) March 31, 2023, 11:38am 3

Sorry it is showing that globalisation is not declared due to protection level

arjunshenoy (Arjun Shenoy) March 31, 2023, 11:44am 4

@murali_potnuri

Looks like System.Globalisation namespace is not available in your project. Can you confirm if it is present in your project dependency?

Best Regards.

murali_potnuri (murali potnuri) March 31, 2023, 12:17pm 5

The dipendency is not there

arjunshenoy (Arjun Shenoy) March 31, 2023, 1:39pm 6

@murali_potnuri

Pease import the specified namespace from the imports panel in the studio:

Hope this helps,
Best Regards.