Please note that the last example you give of dd/mm/yyyy hh:mm:ss will actually return the “date/minutes/year hour:minutes:seconds”. You need to make sure to have capital MM to show the month.
Does anyone know, how to change the language? I’d like to output the following string: “The current month in English is December an in German it’s Dezember”.
March 26, 2012 at 12:59 pm
[…] Web Intelligence Date Formats […]
June 6, 2012 at 12:28 pm
Note: If you want to convert a date string that has military hours, you use HH.
June 9, 2012 at 5:45 pm
Thanks Brian!
April 19, 2013 at 11:33 am
very much useful post.. thank u
July 9, 2013 at 12:43 am
[…] there isn’t a specific date format you can use to give you this information. However, with the use of a number of functions, you can […]
September 25, 2013 at 11:44 am
How to go for a format such as : 16th FEB’13 or 1st FEB’13
October 1, 2013 at 11:54 am
I’m not sure whether you want the month in capitals or the apostrophe after the month.
If you want the month in capitals, subtitute mmm with MMM.
If you want an apostrophe after the month, substitute the space after this statement:
Substr(FormatDate(CurrentDate();”dd/MMM/yyyy”);4;3));” “);
with an apostrophe:
Substr(FormatDate(CurrentDate();”dd/MMM/yyyy”);4;3));”‘”);
I’ve incorporated both changes in this formula:
=Concatenation(Concatenation(Concatenation(Concatenation(Concatenation(If(Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);1;1)=”0″;Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);2;1);Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);1;2));
If (Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);1;2) InList (“1″;”01″;”31″);”st”;
If (Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);1;2) InList (“2″;”02″);”nd”;
If (Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);1;2) InList (“3″;”03″);”rd”;”th”))));
” “);Substr(FormatDate(CurrentDate();”dd/MMM/yyyy”);4;3));”‘”);
Substr(FormatDate(CurrentDate();”dd/mm/yyyy”);7;4))
October 7, 2015 at 9:24 pm
Please note that the last example you give of dd/mm/yyyy hh:mm:ss will actually return the “date/minutes/year hour:minutes:seconds”. You need to make sure to have capital MM to show the month.
December 16, 2016 at 3:57 pm
Does anyone know, how to change the language? I’d like to output the following string: “The current month in English is December an in German it’s Dezember”.
May 10, 2017 at 11:50 am
Can somebody help, I’ve formated date(Start) to “dd/mm/yyyy” but all months ruturns as zeros, what could the problem be?