Adding Time Stamp

[AnnFajardo]

Hi, Everyone 

Seeking for your help I was trying to get yesterday's date together with timestamp but seems the below format I have use is not working 😞 because I got 120000

Ann

------------------------------
Ann Fajardo
------------------------------

[mamichielsen]

Hi Ann, what are you getting if you take out the local time and UTC Time, and instead going FormatDateTime(AddDays(Today(), -1), "yyyyMMddhhmmss")

------------------------------
Melissa Michielsen
Junior Automation Developer
TransAlta
------------------------------

[AnnFajardo]

Hi, Michelsen.

Got the same result if I was going to remove the UTC

------------------------------
Ann Fajardo
------------------------------

[vchinthakindi]

Hi Ann,

Use FormatDateTime Expression instead of FormatDate. And use Now() Expression instead of Today(). It worked for me.

For more expressions, you can expand Functions of Date.

Regards,

Vinod

------------------------------
vinod ch
------------------------------

[AnnFajardo]

Hi, Vinod.

Thanks for the reply yes that's working but I need the yesterday's date instead 😞

------------------------------
Ann Fajardo
------------------------------

[DevendranVenkatesh]

Hi,

Use "(AddDays(Now(), -1)" as part of your logic. That will give you expected results.

------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------

[Mohamad_747]

Hi,

Try with this 

Replace(DateAdd(9,-1,Today()),"/","")&Right(Replace(Replace(LocalTime(),":",""),"/",""),6)&Right(Now()&"",2)

Regards

------------------------------
Mohamad DAKKOURI
------------------------------

[aaron_linton_chambers]

Thank you @Mohamad_747 😊