Page 1 of 1

Date To Num

PostPosted: Sun Apr 30, 2017 1:24 pm
by 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

Re: Date To Num

PostPosted: Sun Apr 30, 2017 2:47 pm
by 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.

Re: Date To Num

PostPosted: Mon May 01, 2017 1:05 am
by 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