How to convert .csv files to .xlsx files

Help Studio
, ,
1

how to convert .csv files to .xlsx files

2

date.AddMonth(-1)

3

Hi,

The following might help you

Regards,

4

Assign: The added or subtracted value results in an un-representable DateTime.
Parameter name: months.

i used this but getting this error

5

i used this but value i am not geting

6

Hi,

Do you have any error?

Regards,

8

Assign: The added or subtracted value results in an un-representable DateTime.
Parameter name: months

this is the error i am getting

9

Hi,

You’re right. The following image might help you.

img20211208-2
img20211208-2862×467 18.5 KB

Or can you share your expression as screenshot or file?

Regards,

10

it is fine and correct but i need only date no timings required

Regards,

11

Hi,

Can you try to use dateTimeVar.ToString("MM/dd/yyyy") instead of dateTimeVar.ToString?

Regards,

1 Like
12

It is working fine thank you .

Regards

1 Like
13

Here is an additional way to work with dates relative to the current date and to convert it to string format.
Dates in string format.txt (1.9 KB)

14

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