Date To Num

[HackinHoodLogicsTm]

Hi NB Team.

I cant seem to convert a formatted date into Julian format

the date format works with dd/mm/yy but wont work with dd/mmm/yy

please any explanations

[Gaev]

HackinHoodLogicsTm:

the date format works with dd/mm/yy but wont work with dd/mmm/yy

From the Help file ...

The date must match the format parameter below.

format
A string that identifies the format of the date. For example:
m/d/y
Month/Day/Year

d/m/y
Day/Month/Year

y/m/d
Year/Month/Day

Default
Use the system’s default date format.

... I do not see support for "month in text" format.

But you can write your own subroutine to change months like Jan, Feb, .... Dec to 01, 02 ... 12 ... and then pass the result to DateToNum.

[HackinHoodLogicsTm]

Thanks Gaev.

But you can write your own subroutine to change months like Jan, Feb, .... Dec to 01, 02 ... 12 ... and then pass the result to DateToNum.

Exactly what am doing