Forum Discussion

glynwilks's avatar
glynwilks
Helper I
4 years ago
Solved

Dynamic Date in Web Query

I am trying to do a POST request using the blank query editior. I need to include a body query within the source to specify the date in yyyy-mm-dd format. If I manually type the date i.e. 2022-05-22 ...
Need Help
Show and Tell
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    For body use this

    body = "{""Dates"":"&""""&Date.ToText(Date.From(DateTime.FixedLocalNow()),"yyyy-MM-dd")&""""&"}",
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

For body use this

body = "{""Dates"":"&""""&Date.ToText(Date.From(DateTime.FixedLocalNow()),"yyyy-MM-dd")&""""&"}",
  • glynwilks's avatar
    glynwilks
    Helper I
    4 years ago

    Thank you very much Vijay. That worked a treat.