C CidTek Active Member Licensed User Longtime User Aug 28, 2013 #1 Using DateTime.DateFormat = "yyyyMMdd" I need to get todays date and yesterdays date. log (DateTime.DateFormat = "yyyyMMdd") Gives me 20130827 which is correct. However while using the same dateFormat... Tmpdate = DateTime.Add(DateTime.Now, 0, 0, -1) Log(tmpdate) gives me 1377498127481 but I expected 20130826 I would like to keep this simple with a few lines of code and not add any libraries such as DateUtils.
Using DateTime.DateFormat = "yyyyMMdd" I need to get todays date and yesterdays date. log (DateTime.DateFormat = "yyyyMMdd") Gives me 20130827 which is correct. However while using the same dateFormat... Tmpdate = DateTime.Add(DateTime.Now, 0, 0, -1) Log(tmpdate) gives me 1377498127481 but I expected 20130826 I would like to keep this simple with a few lines of code and not add any libraries such as DateUtils.
mangojack Expert Licensed User Longtime User Aug 28, 2013 #2 Your Log output was Yesterdays date in "Ticks" .... Code: Dim Today, Yesterday As String Dim TmpDate As Long DateTime.DateFormat = "yyyyMMdd" TmpDate = DateTime.Add(DateTime.Now, 0, 0, -1) Today = DateTime.Date(DateTime.Now) Yesterday = DateTime.Date(TmpDate) Log (Today) Log (Yesterday) Also see here ... Get Yesterdays Date Cheers mj Last edited: Aug 28, 2013 Upvote 0
Your Log output was Yesterdays date in "Ticks" .... Code: Dim Today, Yesterday As String Dim TmpDate As Long DateTime.DateFormat = "yyyyMMdd" TmpDate = DateTime.Add(DateTime.Now, 0, 0, -1) Today = DateTime.Date(DateTime.Now) Yesterday = DateTime.Date(TmpDate) Log (Today) Log (Yesterday) Also see here ... Get Yesterdays Date Cheers mj