topic RE: Expression to add the leading zeros in date if not already exisit in Product Forum

Expression to add the leading zeros in date if not already exisit

Miya — Fri, 09 Jul 2021 20:50:00 GMT

Hi ,

I have to get the date as 02 even if the date appear as 2 or it appears as 02 , so that when i extract the files it should take it as 02, please can someone get the expression for this.

------------------------------
Miya
------------------------------

RE: Expression to add the leading zeros in date if not already exisit

mkumar407 — Fri, 09 Jul 2021 23:28:00 GMT

hi Miya,

Please use Date --> FormatDate Function in calculation stage:

------------------------------
Manish Kumar
------------------------------

RE: Expression to add the leading zeros in date if not already exisit

VedSengupta — Tue, 13 Jul 2021 04:52:00 GMT

Hi Miya,
If you are extracting data from a flat file then is the format of the cell as text?

I have seen it happening myself. When I extract data from Excel for a attribute time and if it is not in text format the value appears as a decimated one.
What I do is format the cell to text and then load it into collection.

------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Bangalore | INDIA
------------------------------
------------------------------

RE: Expression to add the leading zeros in date if not already exisit

EVIPUTI — Thu, 09 Sep 2021 10:26:00 GMT

Yes simply use format date function . It will automatically append a zero if its its 1 digit number .
FormatDate("9/30/2020","dd.MM.yyyy"), --> result (30.09.2020)

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------