ADF Expression - 1st Date of the Prior Month

Mike Kiser 1,536

Hello!
I have the following requirement and need to use it in an ADF Expression: I have thought about this but how would I put this into a Variable (see the following) so that I can later insert it into a Table in an SQL DB?

Thanks!
Mike
@MartinJaffer-MSFT @Nasreen Akter

KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee

2021-02-17T22:02:02.11+00:00

Hi @Mike Kiser ,

Just checking in to see if the below suggestion from @Nasreen Akter was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

Thank you
KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee

2021-02-19T18:14:54.847+00:00

Hi @Mike Kiser ,

Just checking in to see if you have got a chance to try the below suggestion? If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

----------

Announcement : Want to participate in Azure Data Factory hackathon'21? Come hack with us :) - https://aka.ms/adfhack21 (Note: Submission Deadline 24th Feb'21)

Accepted answer

Nasreen Akter 10,801 Reputation points

2021-02-16T23:49:03.753+00:00
Hi @Mike Kiser ,

Please try the following expression. Please pass the date instead of '1/1/2019'. Thanks!

@formatDateTime(subtractFromTime(formatDateTime('1/1/2019', 'M/d/yyyy' ), 1, 'MONTH'), 'M/1/yyyy')

----------

If the above response is helpful, please Accept as answer and Up-vote it. Thanks!
Please sign in to rate this answer.

1 person found this answer helpful.
Mike Kiser 1,536 Reputation points

2021-02-18T04:07:04.047+00:00

Thanks @Nasreen Akter

Our power has been out for almost 24 hours but back on now so I am working. Let me try your solution and let you know how it worked.

Thanks so much for replying!
Mike Kiser

also @KranthiPakala-MSFT

Nasreen Akter 10,801 Reputation points

2021-02-22T17:53:25.213+00:00

Hi @Mike Kiser , if the above answer was helpful, would you please mark the answer as accepted. Thanks!

Mike Kiser 1,536 Reputation points

2021-03-01T16:03:04.117+00:00

Hi, it worked perfectly as usual!
Thanks!
Mike
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF Expression - 1st Date of the Prior Month

0 additional answers

Your answer