Creating a Custom Column from CurrentDate

Question

I'm trying to create a new custom column from a conditional statement and current date.

Next picture explains exactly what i need to get with power query.

An example of what I need from pseudocode is:

if [fecha fin de plazo]>=CurrentDate and [fecha CIERRE investigación]=null
then "string"

My biggest problem is I don't know how to extract the current date with PowerQuery.

Mboolean · Accepted Answer · 2019-10-07 15:12:48Z

1

You could try using,

if [fecha fin de plazo]>= DateTime.LocalNow() and [fecha CIERRE investigación]=null
then "string"

DateTime.LocalNow()

answered Oct 7, 2019 at 15:12

Mboolean

3923 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Noelia Sancho Mendez Over a year ago

almost! your code returns me an error but I was from your request I found out what I needed. To make it work properly I added DateTime.Date() to DateTime.LocalNow(). The result was DateTime.Date(DateTime.LocalNow()) because your code returns me date and time and I'm comparing the columns just by date

Mboolean Over a year ago

@NoeliaSanchoMendez glad you found a way. Though I don't have any way to test given code :)

Noelia Sancho Mendez · Accepted Answer · 2019-10-08 20:28:10Z

1

Using the DateTime.LocalNow you get the date and time of your system, the problem is at time to compareting the date value with the result of DateTime.LocalNow() becsause you need to compare only dates.

That's why It must use DateTime.Date. This fucntion returns the date component of DateTime.LocalNow().

if [date1] >= DateTime.Date(DateTime.LocalNow()) and [date2]=null
then "string"

You can get more information about this functions here:

DateTime.LocalNow()
DateTime.Date()

edited Oct 8, 2019 at 20:28

answered Oct 7, 2019 at 19:33

Noelia Sancho Mendez

1514 silver badges16 bronze badges

2 Comments

β.εηοιτ.βε Over a year ago

Please consider adding at least some explanation as though why this answer the question

herrbischoff Over a year ago

Please add some description to your code explaining what is going on and why. This is good practice. If you don't, your answer is in risk of being deleted. It has already been flagged as low quality.

Collectives™ on Stack Overflow

Creating a Custom Column from CurrentDate

2 Answers 2

2 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Related