topic Re: RE: Adding Time Stamp in Product Forum

Adding Time Stamp

AnnFajardo — Tue, 29 Aug 2023 14:21:00 GMT

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
------------------------------

RE: Adding Time Stamp

mamichielsen — Tue, 29 Aug 2023 15:35:00 GMT

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
------------------------------

RE: Adding Time Stamp

AnnFajardo — Tue, 29 Aug 2023 15:42:00 GMT

Hi, Michelsen.

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

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

RE: Adding Time Stamp

vchinthakindi — Tue, 29 Aug 2023 16:46:00 GMT

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
------------------------------

RE: Adding Time Stamp

AnnFajardo — Wed, 30 Aug 2023 02:40:00 GMT

Hi, Vinod.

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

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

RE: Adding Time Stamp

DevendranVenkatesh — Wed, 30 Aug 2023 06:26:00 GMT

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
------------------------------

RE: Adding Time Stamp

Mohamad_Dakkouri — Wed, 30 Aug 2023 06:54:00 GMT

Hi,

Try with this

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

Regards

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

Re: RE: Adding Time Stamp

aaron_linton_chambers — Wed, 12 Jun 2024 11:47:58 GMT

Thank you @Mohamad_Dakkouri 😊