How to Convert 01.12.2025 into 1. december 2025

Help Studio
,
1

Hi

Date in Excel is 01.12.2025

And i want to convert the date as 1. december 2025.

can someone help?

3

If your date is already a DateTime variable:

ConvertedDate = YourDateVariable.ToString(“d. MMMM yyyy”)

If your date is currently a String:

You must first parse it, then format it:

ConvertedDate = DateTime.ParseExact(“01.12.2025”, “dd.MM.yyyy”, Nothing).ToString(“d. MMMM yyyy”)

image
image1920×1440 467 KB

4

@Latif

If you just want to change format into the Excel file without reading it into datatable, use Excel Process scope and inside it use Format Cells activity and set the desired date format.

If reading the data in a datatable and want to change it’s format use this logic

strFormattedDate = DateTime.ParseExact(yourExcelString, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("d. MMMM yyyy", New System.Globalization.CultureInfo("nb-NO"))
5

If you want to do in excel, there are two ways,

  1. Select date column, click on type and select custom and enter this format:
    d. mmmm yyyy
  2. Using a Formula assuming the date is in cell A1, then use:
    =TEXT(A1,“d. mmmm yyyy”)

If you want to do it using linq, then Ashok’s and Maheep post may help.

6

Hi @Latif,

If you didn’t get the solution, then you can try this:

Syntax 1 (when date is a String like 01.12.2025)
DateTime.ParseExact(strDate, “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“d. MMMM yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToLower

Syntax 2 (when date is already DateTime from Excel):
yourDateTime.ToString(“d. MMMM yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToLower

1 Like
7

@Latif

generally when you read data from excel display value and value read formats might be different..if you want to change in excel use format cells

else firect read data and see the date format which you are getting mostly it would come as mm/dd/yyyy when you see in datatable then use cdate(value).ToString("d. MMMM yyyy")

8

Hi @Latif
Use Assign activity:

outputDate = DateTime.ParseExact(inputDate, “dd.MM.yyyy”,
System.Globalization.CultureInfo.InvariantCulture) _
.ToString(“d. MMMM yyyy”,
New System.Globalization.CultureInfo(“en-US”))

Example

  • inputDate → "01.12.2025" (String)
  • outputDate → "1. December 2025"
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.