I need to get the Monday date records from the Db

[Ronal_bal]

Hi, 

I need to get Monday date records only for the data now available and also I need this process to automate it in the future.


Currently, I have datasets which has 5 days in a week. But i need to extract the records only available on monday.

Is there any way? Any help is welcome

[IraWatt · Accepted solution]

Hey @Ronal_bal,

Do you have any sample data you can provide? A simple way to get only Mondays is to convert a datetime to a Day format with the date time tool:

Then you can use a filter to just grab the Mondays.

Any questions or issues please ask :)
HTH!
Ira

[digitalmemo]

alternatively, you may use this formula @Ronal_bal in a filter tool:

DateTimeFormat([Date],'%a') in ('Mon')

Given that date field is in proper date data type.