Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I want to place the current datetime as my ending date in my JSON String but having some trouble passing the actual variable inside the string
// This is my current time
currentDate = DateTime.ToText(DateTime.LocalNow(), "MM/dd/yyyy hh:mm:00 tt")
{
""name"": ""VideoCallTime"",
""operator"": ""between"",
""value"": [
""2023-08-01T00:00:00Z"",
"¤tDate&"
]
},I looked at some other post and couldnt get and concatination mentioned in those post working.
any suggestions?
Thanks
Solved! Go to Solution.
This worked for me
""" & currentDate & """
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 44 | |
| 43 | |
| 38 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 64 | |
| 31 | |
| 29 | |
| 24 |