Convert Date Format "20-03-2022" To "20-Mar-22"

Help Studio
1

Hi,
i have an excel file , i want to change Date Format “20-03-2022” To “20-Mar-22” for 4 columns–>Transaction_Date,Updated_Date, Payout_Date, Settled_Date
i have tried it but while wring in write excel its not working. writing same data.

can anyone help ?
ConsolidateReport.xlsx (20.1 KB)

image
image1390×663 33.3 KB

DateFormat.xaml (9.0 KB)

2

Hello @Anand_Designer ,

You can use Format Value Activity and change the format of the Date.

EASY OPTION:

Another option is use “Use Excel activity”
use For each Excel Row activity
use Format cell cell activity and select Date as the category and select the Date format

3

image
image1615×707 59.2 KB

bot writing write cell of C2—>3/20/2022 12:00:00 AM but write line Showing “20-Mar-22”. i cant undersnading why bot writing wrong ?

image

4

if you try manually is it working fine?? I hope better you can keep a excel template and format the cells first. Then you can read your excel and paste it to the template. I hope that can modify your date format issue.

5

The bot isn’t writing it wrong. Excel interprets dates and displays them as defined in the spreadsheet. Right click one of the cells and celect Format Cell, and you’ll see why it’s showing it the way it is.

That’s why others said you have to change the format in Excel. It has nothing to do with what you’re writing, it has to do with Excel displaying it based on how the spreadsheet is configured.

6

@Anand_Designer

Try the below expression For Transaction_Date and Updated_Date columns

DateTime.ParseExact(CurrentRow("Transaction_Date").ToString,"dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

Try the below expression For Payout_Date and Settled_Date columns

DateTime.ParseExact(CurrentRow("Payout_Date").ToString,"M/dd/yyyy H:mm", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yy")

Output

Capture

Attached workflow for ref

Example.zip (20.2 KB)

1 Like