vTask Forum - Text() fills the minutes string with a month in this scenario.

Welcome, Guest. Please Login

vTask Forum › vTask Boards › Open Issues and Questions › Text() fills the minutes string with a month in this scenario.

‹ Previous Topic | Next Topic ›

Pages: 1

Text() fills the minutes string with a month in this scenario. (Read 285 times)

JasonB

vTask Expert (200+)

Offline

Posts: 266
Minnesota, USA

Text() fills the minutes string with a month in this scenario.
Feb 16^th, 2010 at 7:37am

vTask v7.73 Windows XP 32bit
If the current Date/Time was 2009-Feb-15 10:56:32

=TEXT(NOW( ), "MMddhhmmss")
Expected: 0215105632 (Excel produces this result)
Actual: 021510

32 because there is no colon, the minutes are mistaken for a month

I'm not asking for an immediate fix for this, just that it gets on your issue log. The following formula works around this issue =SUBSTITUTE(TEXT(NOW( ), "MMddhh:mm:ss"),":","")

IP Logged

vTask Support Moderator Offline Posts: 3596 Tucson, AZ	Re: Text() fills the minutes string with a month in this scenario. Reply #1 - Feb 16^th, 2010 at 7:47am Thanks for the accurate & detailed report. You are correct in both the diagnosis and source identification. And special thanks for the perfect and very creative workaround formula. Nice work! That's worth a star.
Back to top	Thank you for using vTask Studio! IP Logged

vTask Support

Moderator

Offline

Posts: 3596
Tucson, AZ

Re: Text() fills the minutes string with a month in this scenario.
Reply #2 - Mar 10^th, 2010 at 3:07pm

Actually, after doing some testing in Excel, it seems that tag order is the determining factor, not capitalization. For example, the following date/time formulas:

    =TEXT(NOW( ), "MMddMMss")

    =TEXT(NOW( ), "mmddmmss")

both return the same result in Excel.

The issue described in this thread has been fixed with version 7.75. Thanks for the accurate report.

Thank you for using vTask Studio!

IP Logged

JasonB vTask Expert (200+) Offline Posts: 266 Minnesota, USA	Re: Text() fills the minutes string with a month in this scenario. Reply #3 - Mar 11^th, 2010 at 11:23am Confirmed fix. Thank you! --Jason
Back to top	IP Logged

Pages: 1

vTask Forum › vTask Boards › Open Issues and Questions

‹ Previous Topic | Next Topic ›