Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago
Solved

Incremental refresh date parameter to ISO 8601

How to convert Incremental refresh date parameter to ISO 8601?
Date must be provided ISO 8601 (e.g.2020-01-08T11:17:20Z)


i have  webcontents parameters
,Query=
[
from = Date.ToText(RangeStart), // This produce errror
till = Date.ToText(DateTime.Date(Date.AddMonths(DateTime.LocalNow(),0)), "yyyy-MM-dd") //NOW

]

error
Expression.Error: We cannot convert the value #datetime(2022, 1, 1, 0, 0, 0) to type Date.
Details:
Value=2022-01-01 00:00:00
Type=[Type]

But if i use from = Date.ToText(DateTime.Date(RangeStart), "yyyy-MM-ddThh:mm:ssZ")

i got error DataSource.Error: Web.Contents failed to get contents from 

i think this is beacause of escape : to %3A in parameter &from=2022-01-01T12%3A00%3A00Z&till=2022-03-22

 

so how to avoid %3A