Date Functions

MyCondy

Last edited 131 days ago by MyCondy

Text inside "<>" character should be replaced by your real data.

Shows the last date of a month

Date(Year(<VARIABLE>),Month(_actualDate),Day(DateAdd(DateAdd(Date(Year(<VARIABLE>),Month(_actualDate),1),1,TimeUnit.Months),-Day(Date(Year(<VARIABLE>),Month(<VARIABLE>),1)),TimeUnit.Days)))

Start day with Sunday

DateAdd( DateAdd( Today(), 1 - Day( Today() ), TimeUnit.Days ), -( Weekday( DateAdd( Today(), 1 - Day( Today() ), TimeUnit.Days )) - 2 + 1 ), TimeUnit.Days )

⁠

← Text Functions⁠

⁠

Table Functions →⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.