Format COleDatetime

Question

Format COleDatetime

Flaviu_ 1,031

How can I format a COleDateTime valid object like Windows Explorer looks like ?

https://learn.microsoft.com/en-us/cpp/atl-mfc-shared/reference/coledatetime-class?view=msvc-170#format

Is not what I need, because doesn't format the date time like in Windows Explorer ... can you help me ? I didn't find anything on internet ...

I know if user choose another format to the date time from windows settings, my COleDateTime format should track that change ...

David Lowndes 4,726 Reputation points

2022-12-22T18:14:19.06+00:00
What specifically is different with it?
Show your code, and check your regional settings formats.

For this code:

COleDateTime dt( 2022, 12, 22, 18, 9, 29 ); CString str = dt.Format(); std::wcout << str.operator LPCWSTR() << L"\n";

If I have my regional settings (UK) to show the AM/PM indicator, I get this:

22/12/2022 06:09:29 PM

and without the AM/PM indicator set:

22/12/2022 18:09:29

Flaviu_ 1,031

CString CMyDoc::FormatDate(const COleDateTime DateTime) const  
{  
	CString sDateTime;  
#ifdef _UNICODE  
	std::vector<wchar_t> buff(20);  
#else  
	std::vector<char> buff(20);  
#endif // _UNICODE  
  
	do  
	{  
		if (COleDateTime::valid != DateTime.m_status)  
			break;  
  
		SYSTEMTIME systime;  
		systime.wYear = static_cast<WORD>(DateTime.GetYear());  
		systime.wMonth = static_cast<WORD>(DateTime.GetMonth());  
		systime.wDayOfWeek = static_cast<WORD>(DateTime.GetDayOfWeek()) - 1;// 0-nIndex Vs. 1-nIndex  
		systime.wDay = static_cast<WORD>(DateTime.GetDay());  
		systime.wHour = static_cast<WORD>(DateTime.GetHour());  
		systime.wMinute = static_cast<WORD>(DateTime.GetMinute());  
		systime.wSecond = static_cast<WORD>(DateTime.GetSecond());  
		systime.wMilliseconds = 0;  
		if (GetDateFormat(LOCALE_USER_DEFAULT, DATE_SHORTDATE, &systime, nullptr, buff.data(), static_cast<int>(buff.size())))  
		{  
			sDateTime = buff.data();  
			if (GetTimeFormat(LOCALE_USER_DEFAULT, TIME_NOSECONDS, &systime, nullptr, buff.data(), static_cast<int>(buff.size())))  
				sDateTime += CString(_T(" ")) + buff.data();  
		}  
	} while (FALSE);  
  
	return sDateTime;  
}

But the hour it is not correct (one hour before).

Flaviu_ 1,031 Reputation points

2022-12-22T18:43:26.347+00:00

"22/12/2022 06:09:29 PM" its just like in your windows explorer ?
David Lowndes 4,726 Reputation points

2022-12-22T19:42:27.517+00:00

Explorer uses the short time format, but that's the only difference I can see.
David Lowndes 4,726 Reputation points

2022-12-22T19:47:16.387+00:00

And are you 1 hour from UTC?

Installing this VS extension may help your debugging.

YujianYao-MSFT 4,296 Microsoft External Staff

Hi @Flaviu_ ,

Does this code meet your requirements?

#include<iostream>  
#include <ATLComTime.h>  
  
int main() {  
  COleDateTime theTime = COleDateTime::GetCurrentTime();  
  
  CString TimeString = theTime.Format(_T("%m/%d/%Y %I:%M %p"));  
  _ftprintf(stdout, TimeString);  
    
}

RLWA32 49,536 Reputation points

2022-12-23T10:51:30.473+00:00

According to the documentation "COleDateTime ignores Daylight Saving Time. (See Date and Time: Automation Support)"
Flaviu_ 1,031 Reputation points

2022-12-25T07:24:43.633+00:00

The point is to format the date as short date and short time like in windows settings/windows explorer, not a fixed format date.

Accepted answer

0 additional answers

Your answer

David Lowndes 4,726 Reputation points

2022-12-22T18:14:19.06+00:00

What specifically is different with it?
Show your code, and check your regional settings formats.

For this code:

COleDateTime dt( 2022, 12, 22, 18, 9, 29 ); CString str = dt.Format(); std::wcout << str.operator LPCWSTR() << L"\n";

If I have my regional settings (UK) to show the AM/PM indicator, I get this:

22/12/2022 06:09:29 PM

and without the AM/PM indicator set:

22/12/2022 18:09:29
Flaviu_ 1,031 Reputation points

2022-12-22T18:41:30.897+00:00

CString CMyDoc::FormatDate(const COleDateTime DateTime) const { CString sDateTime; #ifdef _UNICODE std::vector<wchar_t> buff(20); #else std::vector<char> buff(20); #endif // _UNICODE do { if (COleDateTime::valid != DateTime.m_status) break; SYSTEMTIME systime; systime.wYear = static_cast<WORD>(DateTime.GetYear()); systime.wMonth = static_cast<WORD>(DateTime.GetMonth()); systime.wDayOfWeek = static_cast<WORD>(DateTime.GetDayOfWeek()) - 1;// 0-nIndex Vs. 1-nIndex systime.wDay = static_cast<WORD>(DateTime.GetDay()); systime.wHour = static_cast<WORD>(DateTime.GetHour()); systime.wMinute = static_cast<WORD>(DateTime.GetMinute()); systime.wSecond = static_cast<WORD>(DateTime.GetSecond()); systime.wMilliseconds = 0; if (GetDateFormat(LOCALE_USER_DEFAULT, DATE_SHORTDATE, &systime, nullptr, buff.data(), static_cast<int>(buff.size()))) { sDateTime = buff.data(); if (GetTimeFormat(LOCALE_USER_DEFAULT, TIME_NOSECONDS, &systime, nullptr, buff.data(), static_cast<int>(buff.size()))) sDateTime += CString(_T(" ")) + buff.data(); } } while (FALSE); return sDateTime; }

But the hour it is not correct (one hour before).
Flaviu_ 1,031 Reputation points

2022-12-22T18:43:26.347+00:00

"22/12/2022 06:09:29 PM" its just like in your windows explorer ?
David Lowndes 4,726 Reputation points

2022-12-22T19:42:27.517+00:00

Explorer uses the short time format, but that's the only difference I can see.
David Lowndes 4,726 Reputation points

2022-12-22T19:47:16.387+00:00

And are you 1 hour from UTC?

Installing this VS extension may help your debugging.
YujianYao-MSFT 4,296 Reputation points Microsoft External Staff

2022-12-23T02:58:56.267+00:00

Hi @Flaviu_ ,

Does this code meet your requirements?

#include<iostream> #include <ATLComTime.h> int main() { COleDateTime theTime = COleDateTime::GetCurrentTime(); CString TimeString = theTime.Format(_T("%m/%d/%Y %I:%M %p")); _ftprintf(stdout, TimeString); }
RLWA32 49,536 Reputation points

2022-12-23T10:51:30.473+00:00

According to the documentation "COleDateTime ignores Daylight Saving Time. (See Date and Time: Automation Support)"
Flaviu_ 1,031 Reputation points

2022-12-25T07:24:43.633+00:00

The point is to format the date as short date and short time like in windows settings/windows explorer, not a fixed format date.

Answer 1

Give this a try -

COleDateTime dt = COleDateTime::GetCurrentTime();  
  
SYSTEMTIME st{};  
dt.GetAsSystemTime(st);  
  
CString strDate, strTime, strDateTime;  
  
int cchDate = ::GetDateFormat(LOCALE_USER_DEFAULT, DATE_SHORTDATE, &st, NULL, NULL, 0);  
LPTSTR pDate = strDate.GetBufferSetLength(cchDate);  
cchDate = ::GetDateFormat(LOCALE_USER_DEFAULT, DATE_SHORTDATE, &st, NULL, pDate, cchDate);  
strDate.ReleaseBuffer();  
  
int cchTime = ::GetTimeFormat(LOCALE_USER_DEFAULT, TIME_NOSECONDS, &st, NULL, NULL, 0);  
LPTSTR pTime = strTime.GetBufferSetLength(cchTime);  
cchTime = ::GetTimeFormat(LOCALE_USER_DEFAULT, TIME_NOSECONDS, &st, NULL, pTime, cchTime);  
strTime.ReleaseBuffer();  
  
strDateTime.Format(_T("%s %s"), (LPCTSTR) strDate, (LPCTSTR) strTime);  
_tprintf_s(_T("%s\n"), (LPCTSTR)strDateTime);

Share via

Format COleDatetime

0 additional answers

Your answer