Convert date to time format

Options
LeiCuntapay
LeiCuntapay
in Modeling

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

Answers

  • SriNitya
    SriNitya
    edited February 27
    Options

    @LeiCuntapay
    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.

Categories