Forum Discussion

Islam's avatar
Islam
Helper V
6 years ago
Solved

Asking About Date Function

Hey Experts i have added a column to my query and add this step targeting type the date and time once a value is entered in items column, here is the formula: #"Added Custom" = Table.AddColumn(#"Ch...
Need Help
  • Islam's avatar
    Islam
    6 years ago

    hi v-juanli-msft  

    thx man for help i just figured out that i can't enter the date only once when i enter data in a specified column like in excel built in function on VBA

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Islam 

each time i refresh the query date changes but i want it to be entered just one time when i enter an item name to the query and when i delete that item name date automatically delete, Any help:)

 

1. Do you want to show date instead of datetime after refreshing each time?

If you want date, please try Date.From(DateTime.LocalNow())

 

2.if you want to delete a column automatically, please refer to:

https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/

 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

csadfasdfsda