How to format CString variable?

Hello everybody! :-) Need some help with my Win32 app - there is some SQL query to mdb file, so one of the fields is date, for example:

SqlString2 = "SELECT Main.[S/N], Employers.Employer, History.Date FROM Main INNER JOIN (Employers INNER JOIN History ON Employers.employer_code = History.employer_code) ON Main.device_code = History.device_code";
SqlString2+=" WHERE [S/N]=";
SqlString2+="' ORDER BY History.Date";
while( !recset2.IsEOF() )



So the problem is - variable sDate looks like "2022-01-24 00:00:00" in this case but I need "24.01.22" - how can I format it? Thank you for advices.

SELECT Main.[S/N], Employers.Employer, FORMAT(History.Date, 'dd.MM.yy') AS Date FROM ...
Last edited on
CString has some formatting but not for dates that I know of.
you have 2 choices, the best one is above: extract it in the format you need instead.
the other one, in the c++, would be to shove the date into c++ date & time tools and pull it back out formatted as you need.
Registered users can post here. Sign in or register to post.