Is it possible to (and how to) convert datetime into a usable value

Is it possible to (and how to) convert datetime such as value output from:
GetFnData("ExDividendDate")
or
GetFnData("Exdivdate)")
to a number+format that I could compare to current date i.e. output from
now(3)

@AzTech, there is a function that convert from DateTime format to DateNum and TimeNum and vice versa.

DateTimeConvert()

exDivDate = GetFnData("ExDividendDate");
exDivNum = DateTimeConvert(0, exDivDate);

Title = StrFormat("Datetime: %s -> DateNum: %1.0f", DateTimeToStr(exDivDate), exDivNum);

More in general, I suggest to save a browser bookmark to the AFL Function Reference - Categorized list of functions and examine the extensive list of functions to manipulates date under the " Date/Time" section.

3 Likes

or you could also refer to the AFL's function list from the help menu into the formula editor:
Schermata 2022-11-10 alle 15.01.49

4 Likes

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.