Not able to get Yesterday's Date in Format -YYYYMMDD

https://forum.uipath.com/t/how-to-get-yesterdays-date/2266/2

As mentioned in this topic where we were extracting yesterday’s date.
It works fine when I mention date format as “DD.MM.YYYY” but it is giving some weird date when trying to get date in format “YYYYMMDD”.

Copying the code again here which I am trying to do
Today.AddDays(-1).ToString(“yyyymmdd”).
e.g today’s date- 01/05/2019
Code is giving me date as 20190030

2 Likes

Hi @EAP
Please try this one:
Now.AddDays(-1).ToString(“yyyyMMdd”) or
Today.AddDays(-1).ToString(“yyyyMMdd”)

It has the same output :slight_smile:

Please refer to these sites:

Thanks and regards,
Despi :slight_smile:

8 Likes

@EAP
Buddy i have something for you…hope this would help you…

The reason why you got such answer is, in yyyymmdd, mm is Minutes with a leading zero

Cheers…!

Format Result
DateTime.Now.ToString(“MM/dd/yyyy”) 05/29/2015
DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015
DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50
DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 AM
DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 5:50
DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 5:50 AM
DateTime.Now.ToString(“dddd, dd MMMM yyyy HH:mm:ss”) Friday, 29 May 2015 05:50:06
DateTime.Now.ToString(“MM/dd/yyyy HH:mm”) 05/29/2015 05:50
DateTime.Now.ToString(“MM/dd/yyyy hh:mm tt”) 05/29/2015 05:50 AM
DateTime.Now.ToString(“MM/dd/yyyy H:mm”) 05/29/2015 5:50
DateTime.Now.ToString(“MM/dd/yyyy h:mm tt”) 05/29/2015 5:50 AM
DateTime.Now.ToString(“MM/dd/yyyy HH:mm:ss”) 05/29/2015 05:50:06
DateTime.Now.ToString(“MMMM dd”) May 29
DateTime.Now.ToString(“yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss.fffffffK”) 2015-05-16T05:50:06.7199222-04:00
DateTime.Now.ToString(“ddd, dd MMM yyy HH’:’mm’:’ss ‘GMT’”) Fri, 16 May 2015 05:50:06 GMT
DateTime.Now.ToString(“yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss”) 2015-05-16T05:50:06
DateTime.Now.ToString(“HH:mm”) 05:50
DateTime.Now.ToString(“hh:mm tt”) 05:50 AM
DateTime.Now.ToString(“H:mm”) 5:50
DateTime.Now.ToString(“h:mm tt”) 5:50 AM
DateTime.Now.ToString(“HH:mm:ss”) 05:50:06
DateTime.Now.ToString(“yyyy MMMM”) 2015 May
11 Likes

Many Thanks Both for providing the solution…It worked for me… :slight_smile:

2 Likes

I was not expecting ,making M in caps will only solve my problem… This adds to my knowledge…:slight_smile:

3 Likes

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