EAP
(Eshna)
May 1, 2019, 7:07am
1
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
Please refer to these sites:
Thanks and regards,
Despi
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
EAP
(Eshna)
May 1, 2019, 8:08am
4
Many Thanks Both for providing the solution…It worked for me…
2 Likes
EAP
(Eshna)
May 1, 2019, 8:11am
5
I was not expecting ,making M in caps will only solve my problem… This adds to my knowledge…
3 Likes
system
(system)
Closed
May 4, 2019, 8:11am
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.