I have already created a variable as Basicstartdate for a date value (07/15/2024) extracted from excel data table. But unable to assign and save in output excel file

Help Activities
1

I have already created a variable as Basicstartdate for a date value (07/15/2024) extracted from excel data table. But unable to assign and save in output excel file.

2

Hi @s.mazumder

How are you saving it to the output excel file. Share the screenshot of flow if possible.

Regards

3

image
image
image

Please let me know if you require more information

4

@s.mazumder

<Assign>
    <To>Basicstartdate</To>
    <Value>DateTime.ParseExact(dtExcelData.Rows(0)("Date").ToString(), "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)</Value>
</Assign>

(0): Refers to the first row in the DataTable.

5

Hi @s.mazumder

What is the format of date you have in Excel can you share that screenshot of excel too.
Regards

6

Hi @s.mazumder

Your query is quite confusing could you be more specific…?

7

Thank you, it is working

1 Like