How to store the pipeline schedule start datetime in a variable?

[Naveen-004]

I'd like to add a notebook parameter that specifies the scheduled start time of the current pipeline run. However, only the pipeline trigger time is available, not the timetable start date.

[v-gchenna-msft]

Hi @Naveen-004 ,

Thanks for using Fabric Community.
If you are looking for start date and time then you can look into this date functions -

ADF generate dynamic date and datetime values | Art of Data Engineering (medium.com)

Hope this is helpful. Please let me know incase of further queries.

[Naveen-004]

I am looking for a pipeline start datetime so that I can pass the value as a parameter to my notebook to fetch updated information during that time.

[v-gchenna-msft]

Hi @Naveen-004 ,

At present we have only Pipeline Trigger Time in Data Factory.
As a workaround, you can use Set Variable Activity at the start of the pipeline like below,

By this you can capture the Date and Time of the pipeline that got triggered.

If you are looking for exact functionality in furture, like Trigger Dare Time.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Docs to refer - Expressions and functions - Microsoft Fabric | Microsoft Learn

Hope this helps. Please let me know if you have any further queries.

[v-gchenna-msft · Accepted solution]

Hi @Naveen-004 ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks