Date Generation within time range

[Anonymous]

Hi all,

How to generate date within specific time range in master calendar.

If suppose time range is yesterday 5pm to today 5pm (03/04/2018 17:00:01 to 04/04/2018 17:00:00)

Can anyone help me to generate the date ??

Thanks in advance.Let me know for more details.

[avkeep01]

Just to exclude this option: did you try name the "Created" field: custom_LinkDate?

Could you send a print screen of the datamodel? Maybe the calender is linked to field "Date" and when you select 4/3/2018 it only shows the custom_LinkDates from 4/3/2018 and of course the updated "created" field.

[dwforest]

Since you're adding 1 to the date, extend your end date of your master calender to Today()+1

[ishanbhatt]

Hi Sindhu,

Please use below logic in your script. Change the vStart and vEnd date format as per your need.

Let vstart = YearStart(Addyears(Today(),-1));

let vEnd  = Today();

for i = '$(vstart)' to '$(vEnd)'

DateTable:

Load

Rowno() as ID,

date($(i))  as Date

autogenerate 1;

next i