Convert date to time format


I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module.

E.g. 10/15/2015

Best Answer


  • SriNitya
    edited February 27

    Directly from date without using period function you cannot fetch Month, you can use workaround mentioned - Find the month number using Month formula from current date
    Create 2 lists number 1- 12 and month list Jan 24 - Dec 24, create mapping of these lists.
    From month number by using number to text, Text to list conversion formulas, FINDITEM() fetch the Month(by means of mapping module using lookup) then by day function you can calculate number of days.
    Any specific reason you want to avoid period function.