Sql

Search

edate dax

EDATE is used when you want to add some number of months to a single date
instead of a column (for which you would use DATEADD)

syntax: EDATE(startDate, numMonths)
returns startDate + numMonths months

examples:
EDATE(18/07/2022, 1) returns 18/08/2022
EDATE(18/07/2022, -1) returns 18/06/2022
EDATE(30/01/2022, 1) returns 28/02/2022 -- edge case for Jan 29th, 30th and 31st

Comment

PREVIOUS	NEXT

Code Example
Sql :: psql human readable
Sql :: oracle sql first day of year
Sql :: mysql drop column
Sql :: oracle sql truncate table
Sql :: day of week postgresql
Sql :: sql get table last modified time
Sql :: Are NULL values in a database the same as that of blank space or zero?
Sql :: start mysql linux terminal
Sql :: sql count columns
Sql :: oracle apex list connected users
Sql :: group by 15 minute interval sql server
Sql :: create table mysql example auto_increment
Sql :: mysql tinyint max value
Sql :: update select
Sql :: sql get number of days between two dates
Sql :: sql drop table statement
Sql :: What is localhost IP and MySql default port no.
Sql :: inner join php my admin
Sql :: go install mysql
Sql :: script to add new column in table sql
Sql :: how to check current user in mysql
Sql :: date 3 months from today sql
Sql :: oracle grant select on schema
Sql :: mysql data types
Sql :: phpmyadmin delete user
Sql :: sql like
Sql :: how to remove default in mysql
Sql :: sql syntax create timestamp column
Sql :: How to convert Varchar to Double in sql?
Sql :: postgresql update between 2 tables

Search

SQL

edate dax

ADD CONTENT