NewDateFormatter Use

[MarenC]

Hi,

I want to get the serial date of the following date:

31/07/2020.

Normally I would subst this and use DayNo.

But I thought I would try the following:

Code: Select all

cDate = '31/07/2020';

vDateFormater = NewDateFormatter('');
vDateCompareSerial = ParseDate(vDate, 'dd/mm/yyyy');
vDateCompare = FormatDate( vDateCompareSerial, 'yyyy-mm-dd' );

I get the following results when I output to excel:

vDateCompareSerial = 21945.004861111
vDateCompare = 31/07/2020

But vDateCompareSerial equates to 31/01/2020 and not 31/07/2020.

What is going on?

Maren

[Wim Gielis]

Did you check the documentation on the date patterns ?
http://userguide.icu-project.org/formatparse/datetime

I would use 'dd/LL/y' and 'dd LL y' for your patterns.

[MarenC]

Hi Wim,

I didn't know I did need to check those patterns so thanks for that.

I see the issue now, the small m was presuming minute.

If I change it as follows it appears to work:

Code: Select all

cDate = '31/07/2020';

vDateFormater = NewDateFormatter('');
vDateCompareSerial = ParseDate(vDate, 'dd/MM/yyyy');
vDateCompare = FormatDate( vDateCompareSerial, 'dd/MM/yyyy' );

Your patterns work too but I wanted the patterns to resemble the vDate and M is more familiar than L for months

thanks for your assistance

Maren

[Wim Gielis]

Hi Wim,

I didn't know I did need to check those patterns so thanks for that.

I see the issue now, the small m was presuming minute.

If I change it as follows it appears to work:

Code: Select all

cDate = '31/07/2020';

vDateFormater = NewDateFormatter('');
vDateCompareSerial = ParseDate(vDate, 'dd/MM/yyyy');
vDateCompare = FormatDate( vDateCompareSerial, 'dd/MM/yyyy' );

Your patterns work too but I wanted the patterns to resemble the vDate and M is more familiar than L for months

thanks for your assistance

Maren

Hi,

indeed MM is an option too.