Hello @Neptune292,
If the formatting options and timezone don't matter for you then use these simple formulas. Like this. Then format the date using default formatting options or using DATETIME_PARSE
Start Date:
DATETIME_PARSE({Work Month})End Date: Same as your's
DATEADD(DATEADD({StartDate},1,'month'),-1,'second')The wrong you've done is you minus -7 hours from the current date. Which affects on the next field as well.
See this screenshot with or without that -7 hour.
I hope this helps.
👍
Hello @Neptune292,
If the formatting options and timezone don't matter for you then use these simple formulas. Like this. Then format the date using default formatting options or using DATETIME_PARSE
Start Date:
DATETIME_PARSE({Work Month})End Date: Same as your's
DATEADD(DATEADD({StartDate},1,'month'),-1,'second')The wrong you've done is you minus -7 hours from the current date. Which affects on the next field as well.
See this screenshot with or without that -7 hour.
I hope this helps.
👍
thanks for your response.
timezone matters for me. i'm trying to set the timezone to my timezone that's why I did the minus 7.
I don't know why the formula calculates it correctly for some months but not others
I was able to fix it by setting the End Date to this:
DATEADD(DATEADD(DATEADD(DATETIME_PARSE(YEAR({Work Month}) & "-" & MONTH({Work Month}) & "-01", 'YYYY-MM-DD'),1,'month'),-1,'second'),-7,'hour')
