Query regarding format of date using DateTimeToday function

[Mohd-Siddiqui1]

Hi there,

I have below stated query. Can someone please help me on this.

I am using one website for fetching data, but before fetching data I need to make some automatic changes in the URL.

website: httpabcdeDate_Effec=20220531xyzdate1=2022-01-31hellothisisadummyURLdate2=2022-03-10

I want Date_Effec (present in above URL) to get updated every day with current day's date. 

I am using DateTimeToday function and I am able to update the Date_Effec with current day's date but format is not matching.

Output I am getting using DateTimeToday: httpabcdeDate_Effec=2022-08-23xyzdate1=2022-01-31hellothisisadummyURLdate2=2022-03-10

Expected Output: httpabcdeDate_Effec=20220823xyzdate1=2022-01-31hellothisisadummyURLdate2=2022-03-10

[DataNath · Accepted solution]

Hey @Mohd-Siddiqui1, you’ll need to wrap DateTimeToday() in your desired format which in this case is YYYYMMDD. To do this you can use:

DateTimeFormat(DateTimeToday(), '%Y%m%d')

Or you could just use simple string functions like Replace() to remove the hyphens as your date is otherwise in the correct format:

Replace(DateTimeToday(),'-','')

[Mohd-Siddiqui1]

Hi @DataNath 

Thank you for the help.