how to calculate the day of the month with JulianDay() function
Hi,
for a given date (provided as an input to the formula) I need to extract the day of the month, the month of the year and the year.
Example:
My input is: 28/01/2014
formula 1 gives me the Day: 28
formula 2 gives me the Month: 01
formula 3 gives me the Year: 2014
formula 2 is: JulianMonth(Today()) - (JulianYear(Today()) * 12)
formula 3 is: JulianYear(Today()) - 4713
But I can't find formula 1
Is there a charitable person here to give me the expression
thanks.
Matthieu