Error in reading cell for date

Hi Guys! I having error when reading the cell as I need to get the date from cell B1.

Problem

Buddy check whether the value is printing in date format or not with write line and then use a read cell activity buddy. and moreover get the output variable as string from read cell and later we can change it as datetime buddy @phoenix123

Hey there…!

Convert the value into date time and then feed it.

Regards :slight_smile:

PS : Guidance on String/DateTime Conversion and String Manipulation

@Palaniyappan hey buddy even though B1 is ######## when i click on it display 30/5/2019. Is there any activity can select the specifc cell?

Error

use read cell activity buddy and mention the cell range as “B1”
and get the output with a variable of type string
Cheers @phoenix123

1 Like

@phoenix123 By the way did you use preserve format option? It definitely give you the date time without corruption of data.

1 Like

@Palaniyappan ok buddy seems you are correct. Thanks for your help! :slight_smile:

1 Like

@Raghavendraprasad yup I did. :slight_smile:

1 Like

so did that work buddy @phoenix123

1 Like

@Palaniyappan yes buddy!

1 Like

Fantastic buddy @phoenix123
Cheers
Kindly make a solution buddy @phoenix123

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